Open another program(Word) with Excel macro?

A

Al

I have created a Word document that is linked to an Excel worksheet so that
I was able to format the printout the way I wanted.
I would like to run a macro that would open that Word document.
Is there a macro command that will open a document in Word(file is linked to
an Excel worksheet).
Does any of this make sense?
 
G

Gary''s Student

Yes: two ways.

1. Put a hyperlink to the word document in a cell. Then you are only a
click away from opeining the do.

2. From VBA:

Sub Macro1()
x = Shell("cmd.exe /c C:\Userguide.doc", 1)
End Sub

will do the same thing
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top