472,125 Members | 1,393 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,125 software developers and data experts.

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 1815
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.