I have a save button on one of my sheets. The code I have linked t
that button uses this command:

application.dialogs.applications.getsaveasfilename

This brings up the right dialog box, however, when i type in a fil
name and press save, the dialog goes away and didn't save anything.

What additional commands to I need to write into the macro to get it t
save. Clearly I am missing something.


Thank

--
jackson
-----------------------------------------------------------------------
jacksonz's Profile: http://www.excelforum.com/member.php...fo&userid=1372
View this thread: http://www.excelforum.com/showthread.php?threadid=26244

hi,
try this instead
Application.Dialogs(xlDialogSaveAs).Show

-----Original Message-----

I have a save button on one of my sheets. The code I
have linked to
that button uses this command:

application.dialogs.applications.getsaveasfilenam e

This brings up the right dialog box, however, when i type
in a file
name and press save, the dialog goes away and didn't save
anything.

What additional commands to I need to write into the
macro to get it to
save. Clearly I am missing something.


Thanks


--
jacksonz
----------------------------------------------------------
--------------
jacksonz's Profile: http://www.excelforum.com/member.php?
action=getinfo&userid=13728
View this thread:
http://www.excelforum.com/showthread...hreadid=262445

.