Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs using cell value
I have a workbook that has a cell which holds a 6 digit number. The first 2
digits of this number designate what folder it needs to be saved in. (eg 12456 should be saved in the "12 series" folder, 08569 should be saved in the "08 series" folder) I want to create a macro that will save the file in the correct folder (J:\My Documents\12 series\) with file name 12456 Pickup.xls. I can't seem to get the syntax right. I don't want it to verify anything, just save the workbook. Any ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs using cell value
Activeworkbook.SaveAs Filename:= "J:\My Documents\" & _ Left(Range("A1").Value,2) & " Series\" & _ Range("A1").Value & " Pickup.xls" -- HTH RP (remove nothere from the email address if mailing direct) "JCanyoneer" wrote in message ... I have a workbook that has a cell which holds a 6 digit number. The first 2 digits of this number designate what folder it needs to be saved in. (eg 12456 should be saved in the "12 series" folder, 08569 should be saved in the "08 series" folder) I want to create a macro that will save the file in the correct folder (J:\My Documents\12 series\) with file name 12456 Pickup.xls. I can't seem to get the syntax right. I don't want it to verify anything, just save the workbook. Any ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SaveAs using cell value
You Rock Bob! Thank you!
"Bob Phillips" wrote: Activeworkbook.SaveAs Filename:= "J:\My Documents\" & _ Left(Range("A1").Value,2) & " Series\" & _ Range("A1").Value & " Pickup.xls" -- HTH RP (remove nothere from the email address if mailing direct) "JCanyoneer" wrote in message ... I have a workbook that has a cell which holds a 6 digit number. The first 2 digits of this number designate what folder it needs to be saved in. (eg 12456 should be saved in the "12 series" folder, 08569 should be saved in the "08 series" folder) I want to create a macro that will save the file in the correct folder (J:\My Documents\12 series\) with file name 12456 Pickup.xls. I can't seem to get the syntax right. I don't want it to verify anything, just save the workbook. Any ideas? |
Reply |
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 | |||
Set Saveas Filename from Cell Contents Using VBA | Excel Programming | |||
Macro to open SaveAs... and change filename to cell value | Excel Programming | |||
Problems with active cell after saveas | Excel Programming |