DDEInitiate( _ app:="Win Word", _ topic:="C:\WINWORD\FORMLETR.
Description End Sub ' don't repeat the end sub, this is just for your reference.
also, please comment out your On Error Resume Next Run this again and see if there are no errors thanks RX- I did not even see the on error resume next I give your code3 a go to see what I get.
Step 3: Insert a code module from then insert menu.
Step 4: Copy the above code and paste in the code module which have inserted in the above step.
either disable events or put the screenupdating within the if statement. Screenupdating = True, the screen will redraw even when it does not need to.
It is better to only turn off screenupdating when necessary.
Display Alerts Application Property in VBA has Boolean value either True or False. When the value is True it displays alerts and messages while running a macro.
If the value is False it doesn’t display any messages or alerts.
Please find the more information and syntax in the following chapter. In the above syntax Application represents object and Display Alerts is the Property of Application object.
Please find the below example for Display Alerts Property of application object in excel VBA.
' This includes both posting free demo projects made from this ' code as well as reproducing the code in text or html format.