Compatibility 2003-2007
 

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

Compatibility 2003-2007
 

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

That is surely the cause. Uncheck it.


--
Jim
"Marc Gendron" wrote in message
...
| 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

Compatibility 2003-2007
 

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)



"Marc Gendron" wrote in message
...
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

Compatibility 2003-2007
 

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.

--
Regards,
Tom Ogilvy


"Marc Gendron" wrote:

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

Compatibility 2003-2007
 

Problem solved

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

"Marc Gendron" wrote:

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

Compatibility 2003-2007
 

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

"Tom Ogilvy" wrote:

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.

--
Regards,
Tom Ogilvy


"Marc Gendron" wrote:

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