CurDir

[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

 

[Bob Phillips]

Help has the syntax, but use ChDrive as well.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

 

[Guest]

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

 

[Ron de Bruin]

Hi Bryan

Try this

Workbooks.Open CurDir & "/ron.xls"

 

[Bob Phillips]

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)

 

[Bob Phillips]

oops wrong question.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)