Compatibility 2003-2007

[Marc Gendron]

Can anyone explain to me why Excel 2007 bugs when I execute my 2003 macros.
It seems to bug only when a date statement is met. Be it "Today", "Time" or
"Date", it tells me it can't find the library. I've checked my references
and eurotool is marked as missing. Can that be the cause and how can I
correct it?

Thanks in advance
Marc

 

[Jim Rech]

Can that be the cause and how can I correct it?

That is surely the cause. Uncheck it.


--
Jim
| Can anyone explain to me why Excel 2007 bugs when I execute my 2003
macros.
| It seems to bug only when a date statement is met. Be it "Today", "Time"
or
| "Date", it tells me it can't find the library. I've checked my references
| and eurotool is marked as missing. Can that be the cause and how can I
| correct it?
|
| Thanks in advance
| Marc

 

[Bob Phillips]

Start by unchecking that reference. Although it may seem unrelated, this is
often the cause of such problems.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Tom Ogilvy]

Yes, that could and probably is the cause.

Un-select it in the references or use the browse button in the references
dialog to find it or install it and do that.

 

[Marc Gendron]

Problem solved

As usual, you guys have been very helpfull. It's real nice to know there
are lifeguards in this VBA Ocean. Thanks

 

[Gizmo]

I am having the same problem. when I try to open a user form (created in
2003)that autopopulates the date, the macro stops and i get the project or
library not found error. I have checked the references and cannot find the
eurotool.
what else could be wrong