Macro to save a workbook that it is NOT IN

[Djflare]

Hey Excel gurus,

I'm trying to make a macro that will be in a empty workbook. I want the macro to save a whole different workbook. Unforunately, i'm really new to this and only know the activeworkbook and this workbook commands. Here is the path of the workbook that I want saved S:\Production\C9\C9 Coat weight data . Also I want the macro to run automatically when the empty workbook is opened b/c I will have a windows scheduled task opening it every 7 days. Basically my whole object is to save the workbook at S:\Production\C9\C9 Coat weight data every 7 days.

Please Login or Register  to view this content.

[BigBas]

I presume there is a workbook that is essentially the template, and Windows Scheduler will open this template workbook. If that's the case, your code should work fine, but the code should be moved into the Workbook module. In order to do this, insert a module and use the Subroutine name Auto_Open. Try this and let me know if it works.

Please Login or Register  to view this content.

[Djflare]

Right, windows scheduler will open the empty workbook. However, the file I want to save is not that workbook so "Active Workbook" shouldn't work. Especially since the file will not necessarily be open.

---------- Post added at 01:31 PM ---------- Previous post was at 01:26 PM ----------

I don't want to put the module in the actual workbook I want to save b/c I don't want that work book saving everytime somone opens it.

[BigBas]

Understood. Your code will look similar to the following (make changes as needed)

Please Login or Register  to view this content.

Does this help? Are you able to translate it to your workbook? (Obviously, in my code replace the path with the path of your workbook)

[Djflare]

Thanks a lot! This is exactly what I needed, I'll mark my post Solved.

[BigBas]

AWesome. Glad it worked.