Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
macro word/excel
Name: aparmar Date: July 23, 2007 at 02:39:54 Pacific OS: xp sp2 CPU/Ram: 1.60Ghz/ 1GB Ram Product: 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.
Name: DerbyDad03 Date: July 23, 2007 at 06:58:26 Pacific
Reply:
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.
0
Response Number 2
Name: aparmar Date: July 23, 2007 at 08:08:11 Pacific
Summary: Hey, Does anyone out there know how can I convert Word Excel stuff to PDF?? I use PDF999 but I need something else which will allow me to specify some feilds on the PDF where people can enter stuff li...
Summary: Hi, When I open a excel doc in IE, I can only save the changes in my local machine and not the Web server. The requirement is that, I should be able to save the changes on the web server. So I have...
0 
