Running a Word macro from Excel
Hi,
I have created a macro in word to edit a file and saved the macro in the Normal.dot file. I can access the macro from within word.
Now, I have written another macro in Excel that basically opens each word file in a directory. Now I want to run the macro after opening the file. The macro name is FindWordCopySentence.
I have tried using appWD.run macroname:=FindWordCopySentence, but this does not work.
Is there a way I can run the macro or send keystrokes to Word using Sendkeys. The shortcut for the macro is ATL + 4. I tried using appWD.Sendkeys ("%4"), this doesn't work either.
Kindly advice.