"Action can not be completed because the program is busy" Error while running the Macro.

Hi,

I have written a macro to update a model based on a input excel sheet. While running it, some times I am getting this error and sometimes its doing fine.

Can anybody help me with this.

Thanks,

_ayyappa.

  • I'm not sure what causes this, but I make it a practice not to hide any spreadsheets being processed by my macros. That allows me to click on the spreadsheet to give it focus to make the dialog go away.
  • In reply to spfister:

    This usually happens when you are running low on memory and you have an intensive macro running. I've found that any macro using Excel runs a bit slower and it's usually Excel that's causing this. If possible you may want to consider reading/writing from a tab delimited file instead of directly from Excel. This will greatly speed things up.