| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CurDir | Excel Programming | |||
| Curdir | Excel Programming | |||
| CurDir does not work | Excel Programming | |||
| CurDir | Excel Programming | |||
| Excel 97 VBA - CURDIR, not reliable | Excel Programming | |||
Hybrid Mode
