Visual Basic Error

[Bill]

Hello

I have a macro that runs well on different Excel versions. But I came
across the following message on Windows XP.

"component not correctly registered" followed by Microsoft Visual Basic
error 336 not expected.

Any ideas? Thanks.

Bill

 

[Don Guillett]

As always, post your code without an attachment.

 

[Bill]

The code is very long. Any ideas based on the error nessgage?

 

[Dave Peterson]

Are you using any non-excel components (like on a userform)?

If yes, maybe re-registering them with windows would help:

windows|start button
regsvr32.exe pathandfilename.xxx

If no, maybe reregistering excel would help:

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.