Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How do I turn off the "do you want to save" alert in excel? | Excel Discussion (Misc queries) | |||
Excel 2003 VBA - "Maximizing" Window & "Calculating" Workbook | Excel Programming | |||
freeze window creates multiple "views" suffixed with ":n" | Excel Discussion (Misc queries) | |||
Error msg "Microsoft Excel is waiting for another application to complete an OLE action" | Excel Programming |