software

I need to create a quot;save filequot; command in my macro which allows the file
to save to the current directory to prevent quot;run errorsquot; 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!

--
9119
------------------------------------------------------------------------
9119's Profile: www.excelforum.com/member.php...oamp;userid=30593
View this thread: www.excelforum.com/showthread...hreadid=502418
You could try in VBA:

ActiveWorkbook.SaveAs CurDir amp; quot;filenamequot;

Not sure if this is what your after--
nickysquawkes
------------------------------------------------------------------------
nickysquawkes's Profile: www.excelforum.com/member.php...oamp;userid=30630
View this thread: www.excelforum.com/showthread...hreadid=502418
Thanks Nicky... that works fine for my purposes. --
9119
------------------------------------------------------------------------
9119's Profile: www.excelforum.com/member.php...oamp;userid=30593
View this thread: www.excelforum.com/showthread...hreadid=502418