CReate a new workbook and copy the name of another workbook

[superbob]

Hi,

I have some code which when run from my "main" workbook it creates a new workbook then saves it to the same location as my "main" workbook. What I also need to be able to do is copy the workbook name of my "main" workbook and add a date and timestamp to the end of the filename. I can't hardcode it as "main" because this workbook name changes.

Any ideas?

[antoka05]

You can try with this macro:

Please Login or Register  to view this content.

Regards,
Antonio

[superbob]

Thanks but I need the code to use the name of the "main" workbook without forcing it by hardcoding the name in the VBA. THe problem is, the name of the workbook will change and won't always be called "main" as it depends on what the user wants to call it. SO I need the code to create a new workbook with the same name as the workbook where the code is run from and add the date and time stamp.

Does that make sense?

[antoka05]

I hope this code is what you need:

Please Login or Register  to view this content.

Regards,
Antonio