By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,491 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,491 IT Pros & Developers. It's quick & easy.

Open File Dialog

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.