CurDir

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Help has the syntax, but use ChDrive as well.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
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
 
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)
 
oops wrong question.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Back
Top