Use the file dialog

With Application.FileDialog(msoFileDialogFolderPicker)
.Show
MsgBox .SelectedItems(1)


End With


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Bryan Brassell" wrote in message
...
I was looking for the syntax for putting it into a "windows.open
filename="
string with the filename.
--
Regards,

Bryan Brassell
Padgett Business Services
281-897-9141


"Bob Phillips" wrote:

Help has the syntax, but use ChDrive as well.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Bryan Brassell" wrote in
message
...
Need proper syntax for using CurDir to open a file "test.xls" in the
current
directly.
--
Regards,

Bryan Brassell
Padgett Business Services
281-897-9141