View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Mark Mark is offline
external usenet poster
 
Posts: 989
Default work-around found, but wish I could find the real answer.

I haven't found the problem, but I found a work-around.

The problem occurs if the Add-In is not installed, for one of three routines.

So, I tried putting the Applications.Addins().Intsalled = True command in
the workbooks Open event, and also uninstalled it in the before_close event.

This works, though I'd still like to know what the problem is.