Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro
hi, how do i write a macro save the file. i mean - the macro will get t "file" then "save as" then the user (not the macro) has to enter th name he wants to save, and then - after klicking on the ok bottom th macro will go on. thank ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro
Try something like the following:
Dim FName As Variant FName = Application.GetSaveAsFilename( _ filefilter:="Excel files (*.xls),*.xls") If FName = False Then ' user clicked cancel Else ThisWorkbook.SaveAs Filename:=FName End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "a_d66" wrote in message ... hi, how do i write a macro save the file. i mean - the macro will get to "file" then "save as" then the user (not the macro) has to enter the name he wants to save, and then - after klicking on the ok bottom the macro will go on. thanks ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |