Recording Macros

[Igwiz]

Hi,

How can I use the Macro Recorder to record actions outside of Excel eg Open up Word and Load a File?

Thanks,
Ig

 

[telephoto]

As far as I know the macro recorder only works to record actions in that program.

Record a macro then edit it via tools/macro/ and use something like

Dim RetVal
RetVal = Shell("""C:\Program Files\Microsoft Office\Office\winword.exe"" ""\\ServerNo\PathTofolder\filename.doc""", 1)

to open the target application and file.

Hope this gives you a clue

Telephoto

 

[fumei]

Macro Record definitely does not record outside of the app that is recording.

Telephoto is right. Make a macro then edit it. However, you could also create an instance of Word and get it to load a file without using Shell.