macro to copy active sheet to a closed workbook in a specified directory

[JEAN1972]

Hi

I am looking a macro to copy the active sheet into closed workbook on C:\\backupdata \SHOPPING\shopbackupdata.xlsx.

Each time the macro is triggered ,the active sheet should always be at last position from the other sheets in shopbackupdata.xlsx

Thanks if anyone can assist

[sintek]

Hi JEAN1972

Can give this a try:

Please Login or Register  to view this content.

[JEAN1972]

Thank you a lot Sinetek, working as requested

[sintek]

Glad I could help....Thanks for rep points...please mark thread as solved.