Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Open a new workbook with a specific name
Hi. Im seeking some help here.
Im trying to open via a Macro a new workbook, do some calcultations and then save this new workbook with a specific name. Problem is that this name is variable (It depends in this case of the Date brought from another workbook). How can i make my macro recogniza this date form the first workbook, and save the second one with this exact variable? This is what i've got so far: Sub exportmonth() Date = Range("b1").Value 'the date taken from the first workbook Cells.Select Selection.Copy Workbooks.Add ActiveWorkbook.SaveAs Filename:="H:\excel\test.xls", FileFormat:=xlNormal _ , Password:="", WriteResPassword:="", ReadOnlyRecommended:=False, _ CreateBackup:=False End Sub In this case the new workbook is saved as text.xls but thats no use for me Any kinda help appreciated Thanx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open Workbook to Specific Worksheet? | Excel Discussion (Misc queries) | |||
How to open a workbook on a specific worksheet. | Excel Worksheet Functions | |||
at startup, i would like a specific workbook to open. | Setting up and Configuration of Excel | |||
How do I open a workbook in a specific sheet | Excel Discussion (Misc queries) | |||
Open workbook to specific worksheet | Excel Discussion (Misc queries) |