Import Spreadsheet within Same database path

[Stoffman]

Does anyone know if it possible to import a spreadsheet with a known name that sits within the same file location as the database however this location isn't known. This database will be in multiple file locations and I want the code to be dynamic
Cheers Chris

 

[PHV]

Have a look at the CurrentProject.Path property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Stoffman]

Thanks for that but as I am only a newbie to this I need a bit more info. I have been looking in the Object Browser and the help, and I can't find anything. Could you give me an example of how this is used

Cheers Chris

 

[PHV]

In the debug window (Ctrl+G) type the following:
? CurrentProject.Path
After pressing the enter you should see the location of your database (provided you don't play with an old version of access).

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Stoffman]

I get a Runtime Error 424. I assume that Access 97 is just too Old. Any other suggestions ???

Cheers Chris

 

[PHV]

So, you may consider playing with the CurrentDb.Name property.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886