FileDialog box

[Malik Al-Amin]

Hi all,

When using the filedialog box to allow a user to select a word document to
open, how do you use the value that they selected and open the document? I
don't think the filedialog has a "filename" property that I can leverage. Is
this correct?

Thanks

Malik

 

[Dave Lett]

Hi Malik,

You don't need to retrieve the filename that they selected. All you really
need is the .Show method. It executes the user's actions in a dialog box.

With Dialogs(wdDialogFileOpen)
.Show
End With

HTH,
Dave

 

[Malik Al-Amin]

Hi Dave,

Thanks for the feedback.
This is the code that I have in the ShowFileDialog:

Sub ShowFileDialog()
Dim dlgOpen As FileDialog
Set dlgOpen = Application.FileDialog( _
FileDialogType:=msoFileDialogOpen)
With dlgOpen
.AllowMultiSelect = True
.Show
End With
End Sub

the .show method opens the dialog box but if I click on a file that file
doesn't open. Do I have to explicitly open it and if so how do I pass the
same name the user selected?

Thanks

Malik

 

[Dave Lett]

Hi Malik,

Have a look at the article "Calling FileOpen dialog in VBA does not allow
opening of multiple files" at
http://word.mvps.org/faqs/macrosvba/OpenMultipleFiles.htm and see if that
solves your problems.

HTH,
Dave