Changing Output Path

[simonc1978]

I have a macro that contains a few ExportWithFormatting commands. What I'd like to do is change the output path so that it doesn't reference a particular drive letter but chooses the current directory that the database is in. So instead of saying H:\{foldername}\{filename.xls} I'd like it to say something like CurrentPath/{filename.xls}

TIA,

Simon

 

[simonc1978]

Update: I think I've found a solution. Will see if it works...

 

[Chad-M]

Try

Environ("path")

This will give the the entire location so maybe use a left statement