Handle an "Excel cannot complete..." alert window withVBA
 

Hi all,

I have written a macro that opens one .xls file and other .htm file that contains excel charts created from the .xls file data.

When the macro says "save and close" the htm-file, I get a message "Excel cannot complete this task with available resources" and stops the macro. Can I write some code to handle this message? (answer ok manually solves the problem, but I want the macro run automatically).

Thank you