Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Office 2000 error
Have you checked the references on the Client machine?
Just open the VBA editor on the clients machine, then under tools you will find a References menu item. Select that menu item. If any of the references are missing, you should see the word "MISSING" next to the problem reference. Also, if Excel initiates a Word VBA macro, do the same in Word. If you find one missing, you can take one of two methods to fix the problem. 1) Uninstall Office on the client computer. Shutdown (to clear memory) then restart the computer. Re-Install office. 2) The reference list will provide you with the name and path that the application expects to find the file. First search the client computer for this file. If you find it in another directory, in references with the MISSING reference selected, browse to the file. If you do not find it you can copy it from another computer (yours) to the expected directory. You may have to register the file manually (others here can tell you how to do that). There is some danger in doing this if you get the wrong version of the file. If you can re-install Office, that is the most sure way of getting everything you need and having it properly registered, etc. Hope that helps! Kevin -----Original Message----- Hello, I have an Excel VBA application that links to a Word template using automation and the Find-Replace method to populate the latter. I have run it without problem in all MS operating systems and Microsoft Office versions. However trying to run it on a customers Dell Latitude laptop it produced the following error populating and printing the Word template: "Microsoft Excel is waiting for another application to complete and OLE application". The error message pops up after successfully printing the 2nd page regardless of the total number of pages to be printed.The application referred to is apparently the winword.exe but no such process seems to be running. Clicking on "ok" closes the message display then re-displays it and nothing else can be done until ctrl-alt-del is hit to shut it down. The Latitude is Pentium RM processor 1600 Mhz with 512 RAM with Windows XP Pro SP 1 and Office 2002/XP SP2. What I don't understand is why it is giving an OLE error message for this version of Office as I thought OLE referred to automation for earlier versions of Office which KB articles on that message also seem to indicate. For now I don't have access to debug the code as the client is long distance. Any ideas what is going on? Any and all help greatly appreciated. Thanks and God bless Van . |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Office 2000 error
Thanks, Kevin.Will check it out.
God bless Van "Kevin" wrote: Have you checked the references on the Client machine? Just open the VBA editor on the clients machine, then under tools you will find a References menu item. Select that menu item. If any of the references are missing, you should see the word "MISSING" next to the problem reference. Also, if Excel initiates a Word VBA macro, do the same in Word. If you find one missing, you can take one of two methods to fix the problem. 1) Uninstall Office on the client computer. Shutdown (to clear memory) then restart the computer. Re-Install office. 2) The reference list will provide you with the name and path that the application expects to find the file. First search the client computer for this file. If you find it in another directory, in references with the MISSING reference selected, browse to the file. If you do not find it you can copy it from another computer (yours) to the expected directory. You may have to register the file manually (others here can tell you how to do that). There is some danger in doing this if you get the wrong version of the file. If you can re-install Office, that is the most sure way of getting everything you need and having it properly registered, etc. Hope that helps! Kevin -----Original Message----- Hello, I have an Excel VBA application that links to a Word template using automation and the Find-Replace method to populate the latter. I have run it without problem in all MS operating systems and Microsoft Office versions. However trying to run it on a customers Dell Latitude laptop it produced the following error populating and printing the Word template: "Microsoft Excel is waiting for another application to complete and OLE application". The error message pops up after successfully printing the 2nd page regardless of the total number of pages to be printed.The application referred to is apparently the winword.exe but no such process seems to be running. Clicking on "ok" closes the message display then re-displays it and nothing else can be done until ctrl-alt-del is hit to shut it down. The Latitude is Pentium RM processor 1600 Mhz with 512 RAM with Windows XP Pro SP 1 and Office 2002/XP SP2. What I don't understand is why it is giving an OLE error message for this version of Office as I thought OLE referred to automation for earlier versions of Office which KB articles on that message also seem to indicate. For now I don't have access to debug the code as the client is long distance. Any ideas what is going on? Any and all help greatly appreciated. Thanks and God bless Van . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Office 2000 error
Kevin,
Thanks again for your tip. I have a followup question regarding your suggestion. It was suggested by another to check the Excel & Word VBA references for any that were missing. The blank instances of each were fine but trying to check for my Excel/Word app is difficult as the client is long distance and I don't want to give them the password to unlock it. So I sent an unlocked copy of the app with code removed. My Office version is 2003 and theirs XP or 2002. When the client installed my app in the right directory it showed all the proper references, correctly showing MS Excel 10.0 Object Library and MS Office 10.0 Office Object Library. But it shows MS Word 11.0 Object Library (what was in the app send from my Office 2003 system) as Missing. Any ideas if that is clue to the problem or what it could be? Would the steps I took above be adequate to check the references or do I need to do it another way? Again, any help appreciated. Thanks and God bless Van " "Kevin" wrote: Have you checked the references on the Client machine? Just open the VBA editor on the clients machine, then under tools you will find a References menu item. Select that menu item. If any of the references are missing, you should see the word "MISSING" next to the problem reference. Also, if Excel initiates a Word VBA macro, do the same in Word. If you find one missing, you can take one of two methods to fix the problem. 1) Uninstall Office on the client computer. Shutdown (to clear memory) then restart the computer. Re-Install office. 2) The reference list will provide you with the name and path that the application expects to find the file. First search the client computer for this file. If you find it in another directory, in references with the MISSING reference selected, browse to the file. If you do not find it you can copy it from another computer (yours) to the expected directory. You may have to register the file manually (others here can tell you how to do that). There is some danger in doing this if you get the wrong version of the file. If you can re-install Office, that is the most sure way of getting everything you need and having it properly registered, etc. Hope that helps! Kevin -----Original Message----- Hello, I have an Excel VBA application that links to a Word template using automation and the Find-Replace method to populate the latter. I have run it without problem in all MS operating systems and Microsoft Office versions. However trying to run it on a customers Dell Latitude laptop it produced the following error populating and printing the Word template: "Microsoft Excel is waiting for another application to complete and OLE application". The error message pops up after successfully printing the 2nd page regardless of the total number of pages to be printed.The application referred to is apparently the winword.exe but no such process seems to be running. Clicking on "ok" closes the message display then re-displays it and nothing else can be done until ctrl-alt-del is hit to shut it down. The Latitude is Pentium RM processor 1600 Mhz with 512 RAM with Windows XP Pro SP 1 and Office 2002/XP SP2. What I don't understand is why it is giving an OLE error message for this version of Office as I thought OLE referred to automation for earlier versions of Office which KB articles on that message also seem to indicate. For now I don't have access to debug the code as the client is long distance. Any ideas what is going on? Any and all help greatly appreciated. Thanks and God bless Van . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
exel error 1706 microsoft office 2000 sr-1 professional | Excel Discussion (Misc queries) | |||
Office 2000/Office 2003 Excel not printing landscape vise versa | Setting up and Configuration of Excel | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Office 2000-Small Business, XCEL eror = copy/paste error | Excel Discussion (Misc queries) | |||
Office 2000 excell sheet gives error message for cell color in of. | Excel Worksheet Functions |