Save Excel with prompt and in a Copy (another workbook)

[countryfan_nt]

Hello friends! Hope all is well!

Please help me, the code below works well. as it creates a copy, but I also want to
see the prompt that allows me to type the file name that I wish to save instead of
ActiveSheet.[N6]

thank you very much in advance!

Please Login or Register  to view this content.

[Alf]

Perhaps adding this modification to your original macro.

Add line

Please Login or Register  to view this content.

Then modify

Please Login or Register  to view this content.

Alf

[Alf]

Thanks for rep

Alf