Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get current directory
I have an excel spreadsheet to read MS Access data.
I would like to put Access database and spreadsheet on the same directory. I need to get current directory to read data through ADO connection string. Are there any easy way to get current directory to find my MS Access database? Any information is great appreciated, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
get current directory
you could use ActiveWorkbook.Path
"Souris" wrote: I have an excel spreadsheet to read MS Access data. I would like to put Access database and spreadsheet on the same directory. I need to get current directory to read data through ADO connection string. Are there any easy way to get current directory to find my MS Access database? Any information is great appreciated, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
current directory | Excel Discussion (Misc queries) | |||
Current Directory | Excel Discussion (Misc queries) | |||
FIND CURRENT DIRECTORY | Excel Programming | |||
changing current directory to that of the current open file | Excel Programming | |||
Set The Directory to the Current WB Path | Excel Programming |