problems at Excel 2007 loading

[Guest]

Hello, I just installed office 2007 enterprise, all works fine except that in
Excel each time I start it and then starts to load the Euro Currency Tools
add-in (eurotool.xlam) I get this message: Could not load some objects
because they are not available on this machine

I know that is related to the Euro Currency Tools Add-in because when I
unmark it on the Excel add-ins list so it won't load, Excel loads correctly.

I think the problem has to do with that first I installed office 2007
upgrading my office 2003 but then I deleted the office11 folder inside the
folder Microsoft Office on the Program Files Folder.

I already tried everything, uninstall and deleting any office related
registry entries, deleting the Microsoft Office Folder and installing again
and nothing works.

Maybe I'm passing some registry entry or something.

Any help will be really appreciated. Thank you very much.

 

[Jim Rech]

As far as I can tell the Euro add-in for Excel 2007 wants to use the Excel
2003 REFEDIT.DLL even though it has its own (although less than half the
size). It may fix the problem if you can get a copy of that Excel 2003 DLL
and put it in the old <path to Excel 2003>\Office11 folder, even if it's the
only file there.

--
Jim
| Hello, I just installed office 2007 enterprise, all works fine except that
in
| Excel each time I start it and then starts to load the Euro Currency Tools
| add-in (eurotool.xlam) I get this message: Could not load some objects
| because they are not available on this machine
|
| I know that is related to the Euro Currency Tools Add-in because when I
| unmark it on the Excel add-ins list so it won't load, Excel loads
correctly.
|
| I think the problem has to do with that first I installed office 2007
| upgrading my office 2003 but then I deleted the office11 folder inside the
| folder Microsoft Office on the Program Files Folder.
|
| I already tried everything, uninstall and deleting any office related
| registry entries, deleting the Microsoft Office Folder and installing
again
| and nothing works.
|
| Maybe I'm passing some registry entry or something.
|
| Any help will be really appreciated. Thank you very much.

 

[Guest]

I just did that and now I get a compile error when I start with the Euro
add-in enabled, is there anymore files I need to have on the office11 folder?

 

[Guest]

This are the errors I'm getting now on Excel, this is the compilation error I
mentioned before:

Compile Error in hidden module: this workbook

Then after I click on okay I get this error about that the macro could not
be loaded and makes reference to this: "EUROTOOL.XLAM!onribbonload"

Any ideas of what does that means?

 

[Jim Rech]

The only thing I can suggest is that you register the DLL you copied in.
From the C:\ prompt make the Office11 folder current. Then run REGSVR32
REFEDIT.DLL. If that doesn't help I have no more ideas, sorry.

--
Jim
| This are the errors I'm getting now on Excel, this is the compilation
error I
| mentioned before:
|
| Compile Error in hidden module: this workbook
|
| Then after I click on okay I get this error about that the macro could not
| be loaded and makes reference to this: "EUROTOOL.XLAM!onribbonload"
|
| Any ideas of what does that means?
|
| "Jim Rech" wrote:
|
| > As far as I can tell the Euro add-in for Excel 2007 wants to use the
Excel
| > 2003 REFEDIT.DLL even though it has its own (although less than half the
| > size). It may fix the problem if you can get a copy of that Excel 2003
DLL
| > and put it in the old <path to Excel 2003>\Office11 folder, even if it's
the
| > only file there.
| >
| > --
| > Jim
| > | > | Hello, I just installed office 2007 enterprise, all works fine except
that
| > in
| > | Excel each time I start it and then starts to load the Euro Currency
Tools
| > | add-in (eurotool.xlam) I get this message: Could not load some objects
| > | because they are not available on this machine
| > |
| > | I know that is related to the Euro Currency Tools Add-in because when
I
| > | unmark it on the Excel add-ins list so it won't load, Excel loads
| > correctly.
| > |
| > | I think the problem has to do with that first I installed office 2007
| > | upgrading my office 2003 but then I deleted the office11 folder inside
the
| > | folder Microsoft Office on the Program Files Folder.
| > |
| > | I already tried everything, uninstall and deleting any office related
| > | registry entries, deleting the Microsoft Office Folder and installing
| > again
| > | and nothing works.
| > |
| > | Maybe I'm passing some registry entry or something.
| > |
| > | Any help will be really appreciated. Thank you very much.
| >
| >
| >

 

[Guest]

Is really odd, I did registered REFEDIT.DLL and so far nothing, it keeps
giving me nos the compile error in hidden module: This workbook and then that
error on the macro.

Is really odd because now if I reinstall office 2003 on a clean installation
after remove office 2007 and clean any office 2007 related strings I keep
getting the first error of that some objects didn't loaded.

 

[Guest]

my problem is really odd, I know that now is something related to visualbasic
since it marks compilation error first after it tries to load eurotool.xlam
and then it puts those macro error, also when I click on the formules tab
again I get errors comming from the euro add-in about some macros.

Maybe something is messing the Visualbasic runtime?

 

[Jim Rech]

Well, I'm almost positive that the problem is REFEDIT.DLL. I know this
because I spent a long time hacking into this and I have the password to
open the VB project in the add-in so I can see the problem under Tools,
References in the VBE. I tried very hard to get this addin to use another
copy of REFEDIT.DLL (there was one in Windows\System32 and one under
Office12 and one under Office11) but it was never happy unless it could use
the Office11 version.

In your place I might try: Uninstall Office 2007, install Office 2003,
install Office 2007. If the add-in works consider leaving Office 2003
installed. Else uninstall everything except REFEDIT.DLL (i.e., putting it
back exactly where it was).

Would the addin work if Office 2007 was installed on a machine that never
had Office 2003 on it? Anyone in that situation want to try it?

--
Jim
| my problem is really odd, I know that now is something related to
visualbasic
| since it marks compilation error first after it tries to load
eurotool.xlam
| and then it puts those macro error, also when I click on the formules tab
| again I get errors comming from the euro add-in about some macros.
|
| Maybe something is messing the Visualbasic runtime?
|
| "Jim Rech" wrote:
|
| > The only thing I can suggest is that you register the DLL you copied in.
| > From the C:\ prompt make the Office11 folder current. Then run REGSVR32
| > REFEDIT.DLL. If that doesn't help I have no more ideas, sorry.
| >
| > --
| > Jim
| > | > | This are the errors I'm getting now on Excel, this is the compilation
| > error I
| > | mentioned before:
| > |
| > | Compile Error in hidden module: this workbook
| > |
| > | Then after I click on okay I get this error about that the macro could
not
| > | be loaded and makes reference to this: "EUROTOOL.XLAM!onribbonload"
| > |
| > | Any ideas of what does that means?
| > |
| > | "Jim Rech" wrote:
| > |
| > | > As far as I can tell the Euro add-in for Excel 2007 wants to use the
| > Excel
| > | > 2003 REFEDIT.DLL even though it has its own (although less than half
the
| > | > size). It may fix the problem if you can get a copy of that Excel
2003
| > DLL
| > | > and put it in the old <path to Excel 2003>\Office11 folder, even if
it's
| > the
| > | > only file there.
| > | >
| > | > --
| > | > Jim
| > | > | > | > | Hello, I just installed office 2007 enterprise, all works fine
except
| > that
| > | > in
| > | > | Excel each time I start it and then starts to load the Euro
Currency
| > Tools
| > | > | add-in (eurotool.xlam) I get this message: Could not load some
objects
| > | > | because they are not available on this machine
| > | > |
| > | > | I know that is related to the Euro Currency Tools Add-in because
when
| > I
| > | > | unmark it on the Excel add-ins list so it won't load, Excel loads
| > | > correctly.
| > | > |
| > | > | I think the problem has to do with that first I installed office
2007
| > | > | upgrading my office 2003 but then I deleted the office11 folder
inside
| > the
| > | > | folder Microsoft Office on the Program Files Folder.
| > | > |
| > | > | I already tried everything, uninstall and deleting any office
related
| > | > | registry entries, deleting the Microsoft Office Folder and
installing
| > | > again
| > | > | and nothing works.
| > | > |
| > | > | Maybe I'm passing some registry entry or something.
| > | > |
| > | > | Any help will be really appreciated. Thank you very much.
| > | >
| > | >
| > | >
| >
| >
| >

 

[Guest]

Well it seems I reached a dead end because I uninstalled office 2007 and
installed office 2003 and the euro add-in of office 2003 gives me the same
error too.

I made sure to delete any registry keys related to office and nothing.

 

[Guest]

I'm sure there is something else and is related to visualbasic since I'm not
getting the first error, I mean the error I was getting originally was that
some objects could not be loaded but that one desappeared, the only errors I
get now with the euro add-in enabled are compilation errors, and I'm sure
something on the visualbasic compilation part is messed up because all the
errors are on the macros, I opened the Visual Basic Editor and tried to run
the macros of Eurotool.xlam from there and in all of them I got compilation
errors

 

[Guest]

Okay more data on my problem, this sure seems to be a problem with the
Visual basic compiling library that executes the Macros, not only the Euro
add-in is failing also the conditional sum wizard is failing as well the
lookup wizard.

So I think something in the visualbasic files got messed up

 

[Guest]

I get a similar error. It is a Microsoft Visual Basic error message that
reads: "Compile error in hidden module: ThisWorkbook."

I have no clue what is wrong. I uninstalled Office 2003 and then
re-installed it. This is still happening. Microsoft wants a min. of $49 to
even talk about it...and this is their product. Does anyone have something
that will help me solve this problem?

Mark

 

[Don Guillett]

http://www.google.com/search?source...D_en___US219&q=Compile+error+in+hidden+module

 

[Guest]

That's the error I'm getting too and after that I get compilation errors on
the macros of the euro add in as well the add ins for the conditional sum
wizard and the lookup assistant as well but so far seems no one can help with
this

 

[Guest]

I just pull (disengaged) Every Add-in I have in Excel, and the message
stopped showing up. So it has to do with how Microsoft handles the add-ins.

 

[Guest]

Don: I looked for the files mentioned in the link, but none of them show
what the problem file is in the "ThisWorksheet" The other files shown I do
not have the error message for them. I did just take out all the add-ins and
this seems to work. Not the most acceptable solution but I will just have to
live with it, unless someone can give me a Microsoft fix!

 

[Dave Peterson]

It's not the way that MS handles the addins. It's a problem with a specific
workbook/addin.

You were half way done when you unchecked all the addins and noticed that the
problem went away. The last half way will be for you to turn on each of the
addins (one at a time), close excel and restart excel.

That way you'll be able to find the single addin that's causing the trouble.
Then you can turn on all the other addins you want. And go back to the
developer of that troublesome addin and explain the problem.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp

 

[Guest]

My apology Dave. I will go back and tell you exactly which one it was. I
use to enjoy finding problems and then letting the developers know, but today
it was an issue of time. I was out of commission all day on Friday, cause of
the crash that occurred, then today, trying to take this one problem out of
the equation. I just haven't had the time to go back. I will, however, do
what you asked me to do and write back.

 

[Dave Peterson]

Make sure you tell the developer, too.

As much as I hate to fix problems, I'd much rather fix it than have it not work.

 

[Guest]

That's what I did too, I disabled the add-ins for excel, my problem is on
Excel 2007, but even if I uninstall office 2007 and install office 2003 I get
the problem in 2003 too, I also checked the links provided here and none of
them help with the problems since they don't mention anything about a hidden
workbook, also in office 2007 and 2003 my xlstart folders were empty, that's
the odd case.