Excel Office 2000 error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin (anonymous_at_discussions.microsoft.com)
Date: 09/10/04 

Date: Fri, 10 Sep 2004 05:40:41 -0700

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
>
>.
>

Quantcast