Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Printing Word Document from Hyperlink -- Can't get the full path!!! Please Help
I am trying to print a Word document using the address found in
a Hyperlink but I can't get the hyperling full path!!! I want to get rid of the hardcoded "D:\Excel\Matrice\" Can someone help me? Thanks! Here's the working code... Dim oAppWord As Object Dim sFiche As String Dim sChemin As String ' -- I want to get rid of this line... sChemin = "D:\Excel\Matrice\" ' ------------------------------------ sFiche = Range("B5").Hyperlinks(1).Address Set oAppWord = CreateObject("Word.Application") oAppWord.Documents.Open Filename:=sChemin & sFiche With oAppWord.ActiveDocument .PrintOut .Close End With |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to I display the full path of an hyperlink in MS Excel 2000? | Excel Discussion (Misc queries) | |||
How do I display the full file path for a hyperlink in Office 2003 | Excel Discussion (Misc queries) | |||
Hyperlink to a word document | Excel Discussion (Misc queries) | |||
Hyperlink to word document problem | Links and Linking in Excel | |||
Printing Word Document using Excel Programming hangs Word | Excel Programming |