Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Solved
Word VBA File Names
Posted on 2013-01-07
I had a document that was created in Word 2003 (vba 6.5)/Windows XP. One of the operations of this document was to open another document that the user selects when clicking on a command button. This was done through the following code.
We have now moved to a new environment; Word 2010 (VBA 7)/Windows 7.
Since this we have had problems with this code. If the files have been stored on a local drive, when the user selects a file “ “ is added to the file name e.g “”c:\file.docx””. If the file is stored on a network drive, this isn’t the case, so the selected file will be “c:\file.docx”.
Does anyone know why this is happening and whether there is a quick fix rather than having to do an IF statement to see if “” has been added to the file name and deleting if it has?
It is causing a problem because these files can be stored either on a local or network drive so I need a system that works in both scenarios.
Documents.Open fileName:=matrixdoc, ConfirmConversions:=False, _
ReadOnly:=False, AddToRecentFiles:=False, PasswordDocument:="", _
PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _
WritePasswordTemplate:="", Format:=wdOpenFormatAuto, Visible:=False
We have now moved to a new environment; Word 2010 (VBA 7)/Windows 7.
Since this we have had problems with this code. If the files have been stored on a local drive, when the user selects a file “ “ is added to the file name e.g “”c:\file.docx””. If the file is stored on a network drive, this isn’t the case, so the selected file will be “c:\file.docx”.
Does anyone know why this is happening and whether there is a quick fix rather than having to do an IF statement to see if “” has been added to the file name and deleting if it has?
It is causing a problem because these files can be stored either on a local or network drive so I need a system that works in both scenarios.
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
5 Comments
Active 1 day ago
If you are saying that the value of the variable matrixdoc is incorrect, we will need to see the code that produces it.
How is matrixdoc defined? ... essentially ensure it is defined as a string and then this shouldn't happen ... not that I understand how it is happening but I have no such issues when using a string type variable.
Chris
Chris
Active 2 days ago
Sorry, the code that produces the variable is as follows:
Dim dlg As Dialog
Dim matrixdoc As String
Set dlg = Dialogs(wdDialogFileOpen)
If dlg.Display = -1 Then
matrixdoc = dlg.Name
End If
Active 1 day ago
I'm not in a position to test it at the moment, but you could always try using Replace:
matrixdoc = Replace(dlg.Name, """","")
matrixdoc = Replace(dlg.Name, """","")
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
The Selection object is designed for user interaction. It has a Range property, so it can be used in most places that a Range object can. Recorded macros must use the Selection because they are simply copying what the user is doing.
A Range prope…
This is written from a 'VBA for MS Word' perspective, but I am sure it applies to most other MS Office components where VBA is used.
One thing that really bugs me is slow code, ESPECIALLY when it's mine! In programming there are so many ways to…
In this video, we show how to convert an image-only PDF file into a PDF Searchable Image file, that is, a file with both the image (typically from scanning) and text, which is created in an automated fashion with Optical Character Recognition (OCR) …
- Document Management
- Document Imaging
- Adobe Acrobat
- Microsoft Word
- OCR
- Printers and Scanners, Images and Photos, Photos / Graphics Software, *tiff, *PDF
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you!
In this Micro Tutorial, you'll learn yo…
- Microsoft Applications
- Windows 10
- Windows OS
- Fonts Typography
- Windows 7, Microsoft Word
Suggested Courses
Course of the Month7 days, 17 hours left to enroll
715 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.