| 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 | |||
Hybrid Mode
