Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Word Docs from Excel VBA With full path and name 255 chars
Hi All
I have written some Excel VBA code to open Word documents. I gather the full path and name in a string. Dim sFullPathAndName As String sFullPathAndName = fldrTarget.Path & Application.PathSeparator & fTarget.Name Word.Application.Documents.Open sFullPathAndName, ReadOnly:=True Sometimes when I then pass this string to Word.Application.Documents.Open and it is greater than 255 chars I get the error: Run-time error '9105' String is longer than 255 characters. How can I open these documents with full path and name 255 characters. Thanks in advance for any ideas. Chrisso |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening word docs in excel | Excel Discussion (Misc queries) | |||
Handling Errors When Opening Word Docs From Excel VBA | Excel Programming | |||
Printing Word Document from Hyperlink -- Can't get the full path!!! Please Help | Excel Programming | |||
Embedding Word Docs into Excel Worksheets and Then Printing The Word Docs | Excel Worksheet Functions | |||
converting excel docs to word docs | New Users to Excel |