Using a macro to open another document

B

Bex

I want to have a button in Excel which you click on and it takes you into
word to a specific document in word.

Is this possible?

Thanks
 
G

Gary''s Student

The macro:

Sub Macro1()
Dim s As String
s = "cmd.exe /c C:\Hello.doc"
x = Shell(s, 1)
End Sub


will take you to a word doc. Just assign a Forms button to the macro.
 
Top