fname = Application.GetSaveAsFileName()

that will return the fully qualified filename selected. then you need to
use

Activeworkbook.SaveAs fName

See help for additional argument options for GetSaveAsFileName

--
Regards,
Tom Ogilvy

"areddy" wrote in
message ...

Hi,

Thanks for the fast responce.It is working fine.but in the report i
want to place one button and when i click on the button it should
display save as window.

i need that code.how to get 'Save as' window when clicking on the
button...

Please help me on this.

thanks & Regards,
Amar....


+-------------------------------------------------------------------+
|Filename: New Microsoft Word Document.doc |
|Download: http://www.excelforum.com/attachment.php?postid=3970 |
+-------------------------------------------------------------------+

--
areddy
------------------------------------------------------------------------
areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=480523