Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro save a file name from a cell in 1st worksheet
I am new to macros and whish to set up a macro to save a spread sheet with a
backup. I have the cell A1 in the first worksheet giving the file name and path etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro save a file name from a cell in 1st worksheet
Sub backup()
With Workbooks("filename.xls") .SaveAs Format(.Worksheets("sheet1").Range("A1").Value) & ".xls" End With End Sub Hope this helps replace the filename with your file name. "karene" wrote: I am new to macros and whish to set up a macro to save a spread sheet with a backup. I have the cell A1 in the first worksheet giving the file name and path etc. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro save a file name from a cell in 1st worksheet
This is not quite what I think I was trying to do. I have saved a recored
macro and changed create a backup to true so this bit works but the macro is using the specific file name that i recorded the macro on. I have in cell A1 on my first worksheet, the file and path name that I would like the macro to use, but can't seem to get it to understand me! Does this make sense ? Thanks "flow23" wrote: Sub backup() With Workbooks("filename.xls") .SaveAs Format(.Worksheets("sheet1").Range("A1").Value) & ".xls" End With End Sub Hope this helps replace the filename with your file name. "karene" wrote: I am new to macros and whish to set up a macro to save a spread sheet with a backup. I have the cell A1 in the first worksheet giving the file name and path etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro save a workbook whilst increasing file no | Excel Worksheet Functions | |||
save original data after macro is run again | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Automatically save file based on cell value | Excel Discussion (Misc queries) | |||
This one is tricky....Macro to save file as cell value x in di | Excel Discussion (Misc queries) |