CreateObject("Word.Application") fails though Word session starts
- From: tyla@xxxxxxxxxx
- Date: Wed, 2 Apr 2008 16:17:46 -0700 (PDT)
We have an Excel application which fails for some users, sometimes,
with a 1004 at the line:
Set gobjWordApp = CreateObject("Word.Application")
where gobjWordApp has been defined as an Object.
What's interesting is that the Word session has been started, as per
Task Manager. It isn't visible to the user at that point (as expected)
and the gobjWordApp object is undefined.. So while Word is there, it
looks like the reference/pointer back to VBA simply doesn't occur.
Additional hints: Changing the line to a simple
"CreateObject("Word.Application") works fine -- although it's pretty
useless for the application since there's no addressable object for
VBA to interact with.
Re-installing Office doesn't change anything.
The typical environment is Windows XP/SP2 and Office 2003/SP2 or
SP3.
There doesn't seem to be a particular pattern in terms of who this
works for and who it fails for, although we're getting suspicious of
the new Vista-compatible versions of HP printer drivers.
Has anyone had experience with this kind of problem or, even
better, know of a fix?
/ Tyla /
.
- Follow-Ups:
- Prev by Date: Re: Identify User, Copy/Paste Login Info. to File on C:\
- Next by Date: Re: Fading non selected numbers in a form
- Previous by thread: Fading non selected numbers in a form
- Next by thread: Re: CreateObject("Word.Application") fails though Word session starts
- Index(es):