Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SAVE AS MACRO
Hello Gurus, I am trying to create a macro so when the user clicks the save
as command box will appear and then they type in the file name and save. The code below brings the save as prompt up but doesn't save : ( Please help. Dim flToSave As Variant 'brings up save as dialogue filling in file name with Job number Dim flName As String Dim flFormat As Long flFormat = ActiveWorkbook.FileFormat flName = Sheets("summary").Range("f7").Value & _ " " & Sheets("summary").Range("f8").Value & " " & "CHR for Monthly Update" & ".xls" flToSave = Application.GetSaveAsFilename(flName, filefilter:="Excel Files (*.xls),*.xls", _ Title:="Save File As...") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
"Save" macro problem, still prompted to save when closing workbook (?) | Excel Programming | |||
Totally Disabling (^ save ) (Save as) and Save Icon – Which code do I use: | Excel Programming | |||
ASP: Open Excel File with Macro, Allow Macro to run, and then save | Excel Programming | |||
Prompted to save changes after macro save - why? | Excel Programming |