AnnabelleMarie
Programmer
I have an Excel macro that slows down tremendously when I save the changes to a workbook:
Workbooks(fileName).Close saveChanges:=True
If I do not save the changes (saveChanges:=False), the macro runs pretty fast. But of course, I need to save the changes. I'm opening about 100 workbooks, updating a range, and then saving the workbook.
Is there some kind of extra processing that Excel does that I can disable so that it saves faster?
Thanks for any help!
Workbooks(fileName).Close saveChanges:=True
If I do not save the changes (saveChanges:=False), the macro runs pretty fast. But of course, I need to save the changes. I'm opening about 100 workbooks, updating a range, and then saving the workbook.
Is there some kind of extra processing that Excel does that I can disable so that it saves faster?
Thanks for any help!