Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 -- 2003 Compatibility | Excel Discussion (Misc queries) | |||
2003/2007 compatibility | Charts and Charting in Excel | |||
2003 to 2007 Compatibility | Excel Discussion (Misc queries) | |||
Compatibility issues with MS 2003 & 2007? | Excel Discussion (Misc queries) | |||
2003/2007 Compatibility Question | Excel Discussion (Misc queries) |