Macro to Save different sheets to different locations

[Titan001]

Hello everyone.



I have a workbook with a number of sheets say sheet1, sheet2, sheet3 etc..

I need a macro to save:

sheet1 to C:\data\sheet1\sheet1.xls

sheet2 to C:\data\sheet2\sheet2.xls

sheet3 to C:\data\sheet3\sheet3.xls



folder sheet1, sheet2 and sheet3 cannot be replaced because they have special rights assigned to them.



Your help will be greatly appreciated.



Regards,

[davesexcel]

Please Login or Register  to view this content.

[Titan001]

Apologies for this.

This post has been cross posted on:
https://www.mrexcel.com/board/thread...tions.1117607/

Regards,
Clint

[Titan001]

Please Login or Register  to view this content.

Thanks for this.
when I did it, the copy is trying to update the links to the original file.
what do I have to include in the code to copy only values and formats?

thank you.

[Titan001]

The saved file keeps creating a link to the source file

I have tried everything to remove the link in the macro with no luck.

Your help will be greatly appreciated.

Please Login or Register  to view this content.

[davesexcel]

Try this

Please Login or Register  to view this content.

[Titan001]

Worked as a treat... Many thanks for your help..