Open a new workbook, save with date from cell in workbook.

I have VBA code to open a new workbook here is my problem:

I want open a new workbook(2) and save it with a date to be pasted in B1.

I want to then activate workbook(1) and copy selected cells and paste them into workbook2.

Then save workbook2 with the following title (SF_GR110_MMDD)

What I am trying to accomplish is not overwriting this file every time it is created.

Here is the code I have already:

Please Login or Register  to view this content.

Thanks for any help.

I have been trying this code in the file name but it gives me a Syntax error
- plus I can't figure out how to make the file save revert back to the date:

Please Login or Register  to view this content.

Here is what I did:

Please Login or Register  to view this content.

Thanks for posting the solution.

In future, you can post the solution as post 2, so its clear which is the question and which is the solution.