Hi,

I am working on a tool, and when it opens I want it to immediatly do a
save as (I have it read only, and can get the save as to come up, but i
don't want anyone saving the tool where the save as pops up, I want it
to co to their C/Data folder).

The last line in my auto open vba code is below, and that brings up the
save as screen, but i want to direct it to go to C/Data, any help would
be appreciated.

"Application.Dialogs(xlDialogSaveAs).Show"


--
ngarland13
------------------------------------------------------------------------
ngarland13's Profile: http://www.excelforum.com/member.php...o&userid=23713
View this thread: http://www.excelforum.com/showthread...hreadid=401212