I wish to launch an Excel 4 file from a Word 6 macro. On doing this control is now with Excel and the Word macro never completes. I am using DDE.
I think I need to open a channel from Excel back to Word and send the appropriate commands. The problem is that I wish this to work on any PC and therefore need to tell the DDEInitiate method where Word is. I cannot find a way of returning the pathway to the folder/directory where Word resides.