dumb moment

[disgruntled]

I cannot remember how to denote the current directory. It is for the following example:

Set MyXL = GetObject(".\SL_Template.xlt")

It will be bundled up with the dB so i would like it to work regardless of where the user places the folder.

 

[Alexandre]

strDbPath = CurrentDb.Name
strDbFile = Dir (strDbPath)

Current Database directory:
strCurrentDbDir = Left(strDbPath, Instr(strDbPath, strDbFile), -1)

Alex