autosave after cetain macro is run

**miyachow** · 04-27-2013, 08:57 AM

Hi, i need to autosave data after certain macro is run. How should i do this? Is there something to add on my existing macro so that it will autosave after running?
Thanks!! Appreciate your replies

**tehneXus** · 04-27-2013, 09:15 AM

hi,

with the following line the Workbook which contains the code will be saved:

Please Login or Register  to view this content.

Regards

**AndyLitch** · 04-27-2013, 09:16 AM

The last line in your macro should save the workbook ..... Syntax is :- ActiveWorkbook.Save

**tehneXus** · 04-27-2013, 09:25 AM

Please Login or Register  to view this content.

You might run into problems when you have more than one workbook opened, while the code is running, change the focus to another workbook, then the activated will be saved instead of the one which contains the code

Regards