469,635 Members | 1,981 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,635 developers. It's quick & easy.

Open File Dialog

I'm trying to use the File Dialog to select an open a file. Here is
my code:

Set fd = Application.FileDialog(msoFileDialogOpen)

With fd
If .Show = True Then
.AllowMultiSelect = False

'Find the selected file name
For Each varFile In .SelectedItems
strFile = varFile
Next
Else
MsgBox "Select a file."
GoTo FindFile_Exit
End If
End With

I know that I'm missing something here to complete the action. What
do I need to open the file after I use the file dialog to select it?

Also along the same lines what do I have to do to do a Save As with
the file dialog? Thanks in advance for the help.

Oct 23 '07 #1
1 1736
Sorry for reposting this question. I wasn't able to find my original,
but eventually I did.

Oct 23 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by John | last post: by
2 posts views Thread by Jonathan Trevor | last post: by
reply views Thread by Dune | last post: by
5 posts views Thread by charles | last post: by
7 posts views Thread by Peter | last post: by
5 posts views Thread by Stefano Tonello | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.