Creating a copy of the workbook and changing some cells contents

Dear All,

I'm trying to develop a macro that not only a creates a copy of the workbook with a specified name but also changes the content of cell "A1" in the generated copy.

I'd be graetfull if you could help me on this one.

Regards,

Manuel Fernandes

Hi, Manuel. See if this will work for you:

Please Login or Register  to view this content.

HTH

Jason

Thank's Jason

It worked perfectly

Good to hear.

Jason