Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Saving created FILE
Hi,
Just would like to ask help on how to automatically save a created file just by the use of command button. I have below macro code: Sub CSVFILE() Dim sh As Worksheet ActiveSheet.Copy Set sh = ActiveSheet On Error Resume Next sh.Buttons.Delete sh.Rows("1:2").Delete On Error GoTo 0 End Sub I want to "save as" the generated new workbook automatically when I click the command button to create the new wokbook. Is this possible? THANKS! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Saving created FILE
Morning macronewbie
"macronewbie" wrote in message ... I want to "save as" the generated new workbook automatically when I click the command button to create the new wokbook. Is this possible? THANKS! Not sure if you want to be able to choose a path and filename. This is a simpler version: ActiveSheet.SaveAs Filename:="c:\Temp\CSVfile.xls" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
BACKUP file created when saving Excel Workbook with VBA | Excel Programming | |||
open a file automatically which was created yesterday | Excel Discussion (Misc queries) | |||
Saving a file to have the filename of the dated it was created | Excel Programming | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
FILES CREATED AUTOMATICALLY WHILE SAVING | Excel Discussion (Misc queries) |