How can I get the valid full name, before I call .Documents.Open() method

  • Thread starter Thread starter houweipeng
  • Start date Start date
H

houweipeng

Before I call Documents.Open() method, I want to know if the doc's full name
is invalid in any OS(eg, English os, JPN, CN).
 
houweipeng said:
Before I call Documents.Open() method, I want to know if the doc's
full name is invalid in any OS(eg, English os, JPN, CN).
Click to expand...

Don't bother with writing a parser for file names -- that already exists in
Windows. Just include an On Error statement that will redirect the macro's
execution to an error handler if the name is invalid.

Dim MyFileName As String
MyFileName = "X:\bad path\possibly invalid filename.doc"

On Error GoTo BadFileName
Documents.Open(MyFileName)
' rest of the macro...

Exit Sub

BadFileName:
MsgBox MyFileName & " is not valid"


--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
 
You must log in or register to reply here.

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

It failes to call Documents.Open method without VBA installed 1
Macro to copy a whole table and then paste it in a new doc 5
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Application.Run Method in VBA 0
Compiling a document when selecting data from a table I got many undeasirable return 2
Open Word Document using VBA in Excel 6
Pasting Charts into Word then resizing them 1
Method or Data Memeber Not Found for Replacement Method 1

Back
Top