Vba Macro to save File2 if File1 saved

Good day,

This is my first post since I joined the forum. Hopefully not the last.

I have two excel file:
C:\Book1.xls
C:\Book2.xls


I am looking vba to do the following:

Whenever I do Save for Book1, I want Book2 to auto save without prompt.

Thank you for your help in advance.

Hi abbasabdulla,
Welcome to the forum. We certainly hope that you will share many more posts with us here.

As to your query, please try the following code (should be saved within Workbook_AfterSave event of Book1):

Please Login or Register  to view this content.

Let us know if anything. Regards.

Dear jewelsharma,

I am using excel 2003, the code doesn't do any action and there is no error message.
I prefer if the code can be placed in a separate file other than book 1or 2.

Hi abbasabdulla,
To answer your queries,

I am using excel 2003, the code doesn't do any action and there is no error message.

Unfortunately, Excel 2003 does not have the "After Save" event; and hence the code does nothing.

I prefer if the code can be placed in a separate file other than book 1or 2.

I understand that you desire to save Book2 everytime you save Book1; then the code needs to rest in Book1, and be executed when you "Save" it. I can't think of another way. Now, I beleive Excel 2003 has a "Before Save" event, so try this code (which, for the above mentioned reasons, should be within Workbook_BeforeSave event of Book1):

Please Login or Register  to view this content.

This code should execute every time you are about to save Book1 and ask you if you would like to save Book2 as well.
Let us know if anything.

Hi jewelsharma /HaHoBe,

I really appreciate your help and I am very thankful to you. Right now I have no access to pc so once I test the vba code I will let you know my feedback accordingly.

Best regards,
Abbasabdulla

Hi HaHoBe/ jewelsharma,

It seems that this codes does no action in excel 2003. Whenever i paste the code to vba module or class model, it will disappear as soon I exit from VBA editor. Please give me your feedback if there is something can be done.

Hi abbasabdulla,
As Guru Holger pointed out, the code needs to be in "ThisWorkbook" object of your "Book1" file. If you are not familiar with "how to do this", please let us know.
(and remember to save the workbook after pasting the code).
Cheers!

Hi jewelsharma,
I am beginner vba, I am not familiar with that.

Hi jewelsharma /HaHoBe,

Both codes works perfect. Thank you for your help.