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

.

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

.

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

.