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

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

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