Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Saving file in the format "YYMM"
Hi,
I am trying to get a macro to extract a date from a cell (A1), then save the file in the format "YYMM Forecast". May I know what is the code I should type in? I tried the following but it doesn't work: Dim myMonth as String Dim myFileName as String myMonth = Format("H71:J71", "yymm") myFileName = "C:\" & myMonth & " Forecast.xls" ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlWorkbookNormal Thanks. |
#2
|
|||
|
|||
There is a "Range" missing in the code.
myMonth = Format(Range("H71"), "yymm") "Dolphinv4" wrote: Hi, I am trying to get a macro to extract a date from a cell (A1), then save the file in the format "YYMM Forecast". May I know what is the code I should type in? I tried the following but it doesn't work: Dim myMonth as String Dim myFileName as String myMonth = Format("H71:J71", "yymm") myFileName = "C:\" & myMonth & " Forecast.xls" ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlWorkbookNormal Thanks. |
#3
|
|||
|
|||
And why do you have 3 cells in your range:
myMonth = Format("H71:J71", "yymm") That may affect the answer. Dolphinv4 wrote: Hi, I am trying to get a macro to extract a date from a cell (A1), then save the file in the format "YYMM Forecast". May I know what is the code I should type in? I tried the following but it doesn't work: Dim myMonth as String Dim myFileName as String myMonth = Format("H71:J71", "yymm") myFileName = "C:\" & myMonth & " Forecast.xls" ActiveWorkbook.SaveAs Filename:=myFileName, FileFormat:=xlWorkbookNormal Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop Excel from saving a file with a different name? | Excel Discussion (Misc queries) | |||
Format of CSV File in export | Excel Worksheet Functions | |||
File Saving with Text from File | Excel Discussion (Misc queries) | |||
When I save a file I consistently get a message about saving a co. | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions |