opening a word file from VBA in Excel 1

[handlewithcare535]

I am trying to open a word file from a command button in excel. I've been trying to use:

filenam = "\filename.doc"
loc = activeworkbook.path
helpfil = loc & filenam

RetVal = Shell("C:\Program files\Microsoft Office\Winword.exe " & helpfil, vb normal focus)

However, this does not work. It opens word, and then an error box saying:

Word experienced an error trying to open the file. Try the following:
- check the file permissions for the document or drive
- make sure there is sufficient free memory and disc space
- open the file with Text Recovery converter.

I do not understand what this means - does anybody know what could be wrong? Or does anybody know another way to open a word file from excel?

Thanks

hwc535

 

[PHV]

You may try to replace this:
helpfil = loc & filenam
with this:
helpfil = chr(34) & loc & filenam & Chr(34)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[firefytr]

Check out the FollowHyperlink method.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[fumei]

Or, instead of using Shell, make an instance of Word...and just open the file. Shell is going to make an instance of Word anyway, so why not just make Word?

Gerry
My paintings and sculpture

 

[handlewithcare535]

Thanks a lot PHV, this worked a treat!