Computing.Net > Forums > Office Software > macro word/excel

macro word/excel

Reply to Message Icon

Original Message
Name: aparmar
Date: July 23, 2007 at 02:39:54 Pacific
Subject: macro word/excel
OS: xp sp2
CPU/Ram: 1.60Ghz/ 1GB Ram
Model/Manufacturer: Toshiba laptop
Comment:

hi,
How do you activate a macro so that is from an excel workbook/sheet, it will jump to a Word document?
Any ideas and help would be great.

Thanks
Amit


Report Offensive Message For Removal


Response Number 1
Name: DerbyDad03
Date: July 23, 2007 at 06:58:26 Pacific
Subject: macro word/excel
Reply: (edit)

Replace path_to_file and filename to match your file.

Sub openWordDoc()
Dim app As Object
Set app = CreateObject("Word.Application")
app.Visible = True
app.Documents.Open Filename:="C:\path_to_file\filename.doc"
End Sub

Or you could just insert the icon for the document and link it to to file. Double-Click the icon and the doc should open.

In either case, moving the Word document to another folder could cause a problem.



Report Offensive Follow Up For Removal

Response Number 2
Name: aparmar
Date: July 23, 2007 at 08:08:11 Pacific
Subject: macro word/excel
Reply: (edit)

Thank you very much, you've help a so much.


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: macro word/excel

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




How often do you use Computing.Net?

Every Day
Once a Week
Once a Month
This Is My First Time!


View Results

Poll Finishes In 2 Days.
Discuss in The Lounge