Should the user's selection of a file in the file dialog open actually open
the selected file or does it just select the file?

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
End With

Will just return the filename

HTH
--
AP

"Mitch" a écrit dans le message de
...
Should the user's selection of a file in the file dialog open actually
open
the selected file or does it just select the file?

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
End With

Mitch,

Add "Execite" to open it:

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
.Execute
End With
hth,

Doug

"Mitch" wrote in message
...
Should the user's selection of a file in the file dialog open actually
open
the selected file or does it just select the file?

With Application.FileDialog(msoFileDialogOpen)
.AllowMultiSelect = False
.Show
End With

"Doug Glancy" wrote in message
...

Add "Execite" to open it:

If only ... <g

Must be my subconscious at work.

Doug


"Bob Phillips" wrote in message
...

"Doug Glancy" wrote in message
...

Add "Execite" to open it:

If only ... <g

LOL!

"Doug Glancy" wrote in message
...
Must be my subconscious at work.

Doug


"Bob Phillips" wrote in message
...

"Doug Glancy" wrote in message
...

Add "Execite" to open it:

If only ... <g