 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2007problems at Excel 2007 loading
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. 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.  SignatureJim | 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 [quoted text clipped - 15 lines] | | Any help will be really appreciated. Thank you very much. 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? > 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 [quoted text clipped - 24 lines] > | > | Any help will be really appreciated. Thank you very much. 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? > 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 [quoted text clipped - 24 lines] > | > | Any help will be really appreciated. Thank you very much. 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. SignatureJim | This are the errors I'm getting now on Excel, this is the compilation error I | mentioned before: [quoted text clipped - 34 lines] | > | | > | Any help will be really appreciated. Thank you very much. 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. > 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 [quoted text clipped - 46 lines] > | > | > | > | Any help will be really appreciated. Thank you very much. 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? > 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 [quoted text clipped - 46 lines] > | > | > | > | Any help will be really appreciated. Thank you very much. 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? SignatureJim | 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 [quoted text clipped - 53 lines] | > | > | | > | > | Any help will be really appreciated. Thank you very much. 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. > 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 [quoted text clipped - 83 lines] > | > | > | > | > | > | Any help will be really appreciated. Thank you very much. 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 > 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 [quoted text clipped - 83 lines] > | > | > | > | > | > | Any help will be really appreciated. Thank you very much. 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 > 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 [quoted text clipped - 83 lines] > | > | > | > | > | > | Any help will be really appreciated. Thank you very much. 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 http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GFRD_en___US219& q=Compile+error+in+hidden+module SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > > I get a similar error. It is a Microsoft Visual Basic error message that [quoted text clipped - 8 lines] > > Mark 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! > http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4GFRD_en___US219& q=Compile+error+in+hidden+module > [quoted text clipped - 9 lines] > > > > Mark 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. > 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 [quoted text clipped - 15 lines] > > > > > > Mark >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. Check all the places where your OS keeps files for XL. I had a similar problem and xl was getting files from a few places before it got to xlstart :) I have been given a spreadsheet created in XP Pro with 2003 Excel. I was able to open and use it with the same setup. I now have XP Pro with 2007 on a completely new system. When I attempt to open the file from the email attachment it acts like it is going to open in 2007 for a few seconds. I can see the file and it looks correct. It then shows the EUROTOOL.XLAM in the bottom of the 2007 Excel for a second and then gives me the - Do you want to send Microsoft error notice. I have duplicated the same results on another new system with XP Pro and 2007 Excel. Any suggestions? > >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 [quoted text clipped - 6 lines] > problem and xl was getting files from a few places before it got to xlstart > :) What do you know? I just installed the Service Pack 1 of Office 2007 and that solved the Eurotool problem, I just checked it and it is working now :) > 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 [quoted text clipped - 15 lines] > > > > > > Mark What does this have to do with Excel 2003 and a "compile error in hidden module"? Or are you so overjoyed you highjacked an irrelevant thread to share your success? If the latter.....good to hear. Gord Dibben MS Excel MVP >What do you know? I just installed the Service Pack 1 of Office 2007 and that >solved the Eurotool problem, I just checked it and it is working now :) [quoted text clipped - 18 lines] >> > > >> > > Mark Err... check the title of the thread my friend I did started it and in fact the problem I had with the Eurotool was precisely a compile error too, but as the topic advanced some user added that he had problems with Excel 2003 as well and must have changed the title on his reply. > What does this have to do with Excel 2003 and a "compile error in hidden > module"? [quoted text clipped - 28 lines] > >> > > > >> > > Mark The title of this thread is "Problems at Excel 2003 loading". The title of the thread you started September 30th was "Problems at Excel 2007 loading". Mark highjacked the thread October 8th and changed the subject line to "Problems at Excel 2003 loading". Apologies for the confusion on my part. Gord >Err... check the title of the thread my friend I did started it and in fact >the problem I had with the Eurotool was precisely a compile error too, but as [quoted text clipped - 33 lines] >> >> > > >> >> > > Mark Sorry I forgot to add a thing on my other reply, I posted that also in case the other people who had this problem in excel 2007 could solve it, because I really doubt I'm the only one with this kind of problem, and it also can be useful for people who browse this communities searching a solution to such problems. > What does this have to do with Excel 2003 and a "compile error in hidden > module"? [quoted text clipped - 28 lines] > >> > > > >> > > Mark 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 > I get a similar error. It is a Microsoft Visual Basic error message that > reads: "Compile error in hidden module: ThisWorkbook." [quoted text clipped - 5 lines] > > Mark 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. > 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 [quoted text clipped - 10 lines] > > > > Mark 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 > 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. [quoted text clipped - 13 lines] > > > > > > Mark SignatureDave Peterson 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. > It's not the way that MS handles the addins. It's a problem with a specific > workbook/addin. [quoted text clipped - 30 lines] > > > > > > > > Mark 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. > 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 [quoted text clipped - 41 lines] > > > > Dave Peterson SignatureDave Peterson I have been given a spreadsheet created in XP Pro with 2003 Excel. I was able to open and use it with the same setup. I now have XP Pro with 2007 on a completely new system. When I attempt to open the file from the email attachment it acts like it is going to open in 2007 for a few seconds. I can see the file and it looks correct. It then shows the EUROTOOL.XLAM in the bottom of the 2007 Excel for a second and then gives me the - Do you want to send Microsoft error notice. I have duplicated the same results on another new system with XP Pro and 2007 Excel. Any suggestions? > It's not the way that MS handles the addins. It's a problem with a specific > workbook/addin. [quoted text clipped - 30 lines] > > > > > > > > Mark |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.