Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook addition
Hi,
I am new to VBA Programming.. In my program i need to open some workbooks between specific dates which i am givin input. The name of the new workbook should be the date and the contents of the new workbook are same as the active workbook.. Please help me in creating the new workbook part alone rest all i have done. If you could provide me some code snippets that would be of much use. thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook addition
Dim filePath As String, fileName As String filePath = "C:\" fileName = Format(Date, "yyyymmdd") & ".xls" ActiveWorkbook.SaveAs fileName:=filePath & fileName -- Cheers Nigel "srikanth" wrote in message ... Hi, I am new to VBA Programming.. In my program i need to open some workbooks between specific dates which i am givin input. The name of the new workbook should be the date and the contents of the new workbook are same as the active workbook.. Please help me in creating the new workbook part alone rest all i have done. If you could provide me some code snippets that would be of much use. thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook addition
Hi Nigel,
Thanks so much for your quick response.. I got it.. Thanks again.. I am very much excited.. thank you "Nigel" wrote: Dim filePath As String, fileName As String filePath = "C:\" fileName = Format(Date, "yyyymmdd") & ".xls" ActiveWorkbook.SaveAs fileName:=filePath & fileName -- Cheers Nigel "srikanth" wrote in message ... Hi, I am new to VBA Programming.. In my program i need to open some workbooks between specific dates which i am givin input. The name of the new workbook should be the date and the contents of the new workbook are same as the active workbook.. Please help me in creating the new workbook part alone rest all i have done. If you could provide me some code snippets that would be of much use. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cell addition | Excel Worksheet Functions | |||
Addition? | Excel Discussion (Misc queries) | |||
Sum vs. Addition | Excel Programming | |||
addition | New Users to Excel | |||
row addition | Excel Worksheet Functions |