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

S

Santiago Rivas

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Application.OnTime - Macro Cannot Be Found - Internet Explorer 0
Please help! Cannot open pivotTable source file.... 2
"Following Features Cannot be saved" error on LOADING ?? 1
Handle Pop-Up While Navigating with IE 0
Lose macros before saving 4
Excel 2013 cannot open simple text file with .acc extension 1
VBA to copy an htm file into excel 4
Suppress "Opening File" Alert 0

Top