Macro - Workbook save as code help needed

[bonny24tycoon]

Hi Team,

I have a macro build and works fine. But I need to deliver this file for a particular team for their work to be decreased.

My issue is the below code highlighted in red.

Please Login or Register  to view this content.

The above was recorded to save the copy on the desktop. But I see that the macro has saved the path for my desktop.

Can this be built in a way, that once the user runs the macro, the new file should automatically be saved on that users desktop??

[TMS]

Rather than re-invent the wheel, have a look at this link:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=216

You should be able to adapt it to your needs.

Regards, TMS

[bonny24tycoon]

Hi TMShucks

You deserve a rep


Thanks a ton

[TMS]

You're welcome. Thanks for the rep.