| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic SaveAs Worksheet Name
Glad you got it to work!
Shockley "Linc" wrote in message ... Thanks for the response. I ultimately figured out that the string I needed was Activeworkbook.SaveAs "NameofFile_" & Cells(1, 12) This added the counter number to the name of the file and saved it. So the file Incidnet.xls became Incident_1002.xls with 1002 coming from the cell in row one column 12. Thanks for your help too. Linc ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
| howto: saveas with file name from a cell in the current worksheet | New Users to Excel | |||
| SAveAs worksheet | Excel Worksheet Functions | |||
| Automatic updating of a rollup worksheet when a new worksheet is a | Excel Worksheet Functions | |||
| SaveAs problem, renames Worksheet too | Excel Programming | |||
Threaded Mode
