Workbook addition

[Guest]

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

 

[Nigel]

Dim filePath As String, fileName As String
filePath = "C:\"
fileName = Format(Date, "yyyymmdd") & ".xls"
ActiveWorkbook.SaveAs fileName:=filePath & fileName

 

[Guest]

Hi Nigel,

Thanks so much for your quick response..
I got it.. Thanks again.. I am very much excited.. thank you