Open Word from Excel??? 1

[ribhead]

I'm going crazy here! All I'm trying to do is open a Word document in my hard drive. using a command bar that I created in the ("Cell&quot shortcut keys. I have no clue on what I'm doing other than stapling my elids to my bottom lip I haven't accomplished anything. Any help would be great.

For just $19.95 you too can have a beautiful smile.

 

[robcarr]

this is very basic and I hope it helps but this opens test.doc on my C:
Sub MS_Word()
Dim wd As Object
'Create a Microsoft Word session
Set wd = CreateObject("word.application&quot
wd.Visible = True
'Activate MS Word
AppActivate wd.Name
With wd
'Open a new document in Microsoft Word
.Documents.Open Filename:="c:\rob\test.doc"

End With

End Sub

this was edited from the samples.xls file that comes with Excel,

Thanks

Thanks Rob.

 

[ribhead]

Thanks a lot man. I'll even give you a star for this. I don't have a full blown version of Excel so without a help menu I get a little stuck at times.

For just $19.95 you too can have a beautiful smile.