CurDir
 

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

CurDir
 

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

CurDir
 

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

CurDir
 

Hi Bryan

Try this

Workbooks.Open CurDir & "/ron.xls"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"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

CurDir
 

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

CurDir
 

oops wrong question.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
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