Opening Word Docs from Excel VBA With full path and name > 255 chars

C

Chrisso

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Handling Errors When Opening Word Docs From Excel VBA 1
copy cells with more then 255 chars... 7
File Name and Full Path Name 6
Can't pass string >255 characters to Word document with VBA 3
Retrieving data from Excel and store it into string variable 2
Querytables.add with sql query text stored in separate text file 5
Mail Merge with Excel and Word 2007 1
Via VBA, How can I obtain the path from a string of text? 4

Top