Appreciate previous input, but still stuck on Launching Word from Excel

Posted by James Hill on October 02, 2001 3:09 PM

Thanks guys for trying to help me out before, but the code gave me an error when I tried to run it. I guess to keep things simple, how can I launch a specific word file from a specific directory path of my choosing. I am a novice vba programmer and will not really be able to interpret general directions. I would greatly appreciate any help that someone could give me.

Posted by Ryan on October 03, 2001 4:15 AM

Try this, just add it right to thisworkbook. Then put something in your excel to run a macro and call this one.

Sub openwordandfile()
Set myword = CreateObject("Word.basic")
myword.appmaximize True
myword.fileOpen ("C:/filename")
End Sub