If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Open another program(Word) with Excel macro?
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? |
#2
|
|||
|
|||
Open another program(Word) with Excel macro?
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 -- Gary's Student "Al" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Closing File Error | jcliquidtension | General Discussion | 4 | October 20th, 2005 12:22 PM |
Macro - Open Word with Excel macro | Bill | General Discussion | 3 | May 23rd, 2005 11:21 PM |
After Query can a macro Open Excel and a spreadsheet file | Adam | General Discussion | 5 | January 24th, 2005 05:37 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |
Excel File will not open if Excel is no open first | Vyyk Drago | General Discussion | 2 | June 23rd, 2004 01:14 PM |