Saving to "open" directory

[9119]

I need to create a "save file" command in my macro which allows the file
to save to the current directory to prevent "run errors" if the end user
has a different directory tree.

E.g. I may be using a default c:\ directory, but the spreadsheet user
may be on say h:\ directory on a network. The save command needs to be
able to save to the open directory.

Any advice appreciated!

 

[nickysquawkes]

You could try in VBA:

ActiveWorkbook.SaveAs CurDir & "filename"

Not sure if this is what your after

 

[9119]

Thanks Nicky... that works fine for my purposes.