This project has moved. For the latest updates, please go here.

Update xlsm file, save and activating macro.

Aug 8, 2013 at 8:18 PM
I read a xlsm file, update some cells and then save the file. This only works if I have enabled macros before opening it. Once I have saved it I need to enable macros again before I can write to it. If I don't I get error:

Index was outside the bounds of the array.

Now, is it possible to either activate macros when opening the file or save the file in same state (with activated macros) after updating cells? If so, how?