Compile error notice

[gordonrainsford]

I have a spreadsheet with lots of VBA in it that I've used for a number of years. Recently it produces an error message when I open it - Compile error- Automation error.

When I ok it, the VBA editor opens with this line highlighted in blue: "Dim workbook1 as workbook" (Dim is not highlighted).

Closing the editor allows me to continue without any further problem, but it's a bit annoying, especially for other people using it.

Any ideas?

 

[mole999]

do you have Option Explicit at the top of the subs, has there been a change of system, i.e and office upgrade or similar change, loss of expected references, recompiled by someone else on a different spec machine ?

 

[gordonrainsford]

Yes, I always have option explicit at the top. The file is used by many people on many computers. Thanks.