Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - saving files
Hi
I'm trying to create a macro that automatically saves a file with a file name taken from a cell - ie: Order number 12345 I'm sure it should be possible but I do I do it ? Sorry if that's really basic but I'd appreciate any advice. Thanks Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help - saving files
Try
ActiveWorkbook.SaveAs Sheets("mysheet").Range("d1").Value & ".xls" -- Regards Ron de Bruin http://www.rondebruin.nl "MSL" wrote in message ... Hi I'm trying to create a macro that automatically saves a file with a file name taken from a cell - ie: Order number 12345 I'm sure it should be possible but I do I do it ? Sorry if that's really basic but I'd appreciate any advice. Thanks Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel files are saving without any XLS extension. Any ideas? | Excel Discussion (Misc queries) | |||
Excel Saving to Temp File for files on network | Excel Discussion (Misc queries) | |||
Closing files and saving files | Excel Worksheet Functions | |||
Saving Excel files takes a huge amount of time | Excel Discussion (Misc queries) | |||
Saving shared Excel files | New Users to Excel |