Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |