Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Al
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
Gary''s Student
 
Posts: n/a
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2002 Add-in: Open Database Connectivity available for Excel Nick B Excel Discussion (Misc queries) 8 December 7th 06 06:04 PM
CSV formatted files open odly in Excel 2000 Janski Excel Discussion (Misc queries) 3 November 24th 05 07:58 PM
Excel startup switches Randy Excel Discussion (Misc queries) 9 June 14th 05 10:27 PM
Cannot open Excel attachment from e-mail when Excel is already ope John P. Excel Discussion (Misc queries) 1 March 1st 05 08:35 PM
open Word from excel Macro hurst,j Excel Worksheet Functions 0 December 2nd 04 03:27 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"