Return file name from FileOpen.Display?

E

Ed

I'm trying to get the document name from the FileOpen dialog box using
..Display. I'm also trying to set it so the box will open showing All Files,
rather than defaulting to Word docs only. But I can't seem to find the
parameter that returns the file name. Can someone fill in the ???? for me,
please?

Ed

Set dlgFName = Dialogs(wdDialogFileOpen)
With dlgFName
.Name = "*.*"
.Display
strFName = ????
End With
 
E

Ed

Ed said:
I'm trying to get the document name from the FileOpen dialog box using
.Display. I'm also trying to set it so the box will open showing All Files,
rather than defaulting to Word docs only. But I can't seem to find the
parameter that returns the file name. Can someone fill in the ???? for me,
please?
To clarify further: I'm looking for the FullName. Is this possible?
Ed

Set dlgFName = Dialogs(wdDialogFileOpen)
With dlgFName
.Name = "*.*"
.Display
strFName = ????
End With
Click to expand...
 
E

Ed

Thanks for responding, Jezebel. As I played with it while waiting, I typed
..Name, but the AutoComplete didn't come up, so I didn't think it was valid.
I typed it in anyway, and got the file name, but not the FullName, including
path. I also realized I probably couldn't do ".Name = "*.*" to show All
Files when the dialog box comes up. I can do without that, if I can just
get the full name including path.

Ed
 
J

Jonathan West

Ed said:
Thanks for responding, Jezebel. As I played with it while waiting, I typed
.Name, but the AutoComplete didn't come up, so I didn't think it was valid.
I typed it in anyway, and got the file name, but not the FullName, including
path. I also realized I probably couldn't do ".Name = "*.*" to show All
Files when the dialog box comes up. I can do without that, if I can just
get the full name including path.
Click to expand...

Try this

strFName = WordBasic.FileNameInfo$(.Name, 1)
 

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

Help troubleshooting macro, please? 1
Inserting the Window username into MS Word file 4
opening multiple files at once gives error 4
Automation of scanned file storage based on content 0
Macro Code for bringing up Save As dialog box and changing file Type 0
VBA - exporting serial letters to single documents 0
Inserting an audio file and displaying note or label, not the file name 0
Automatically insert "Continued" in footer based on existing STYLEREF 2

Top