Run-time error '424': Object required
| Author |
Message |
|
JAY
#1 / 18
|
 Run-time error '424': Object required We have a standard build. My template works on other PCs. But having a problem on one with this message. Any ideas. I tried CreateObject (word and excel) on that PC and it failed.
Jay
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
 |
|
Cindy Meister -WordMVP
#2 / 18
|
Run-time error '424': Object required Hi Jay, Quote: > I tried CreateObject (word and excel) on that PC and it failed.
You need to go to Tools/Reference in the VB-Editor and activate references to these libraries :-) Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://go.compuserve.com/MSWord
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
|
|
mich
#3 / 18
|
Run-time error '424': Object required Not for a CreateObject call, you don't? Do you think they could add any more irrelevant newsgroups
to this thread? Sheesh. Whatever happened to focus?
--
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote: > Hi Jay, > > I tried CreateObject (word and excel) on that PC and it
failed.
> You need to go to Tools/Reference in the VB-Editor and
activate
> references to these libraries :-)
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister
> http://go.compuserve.com/MSWord
> This reply is posted in the Newsgroup; please post any
follow question
> or reply in the newsgroup and not by e-mail :-)
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
|
|
JAY
#4 / 18
|
Run-time error '424': Object required Do you know what's missing then? I only put it in other groups cause they were VB related. Not everyone checks everygroup, so I usually have better luck posting to several related groups to get the answer. Thanks
Jay
Quote: > Not for a CreateObject call, you don't? > Do you think they could add any more irrelevant newsgroups
> to this thread? Sheesh. Whatever happened to focus?
> --
> MichKa
> -------------------------------------
> don't send questions by e-mail unless
> you're paying for it. (TANSTAAFL!) :-)
> random junk of dubious value and
> replica error and problem fixing at:
> http://www.trigeminal.com
> > Hi Jay,
> > > I tried CreateObject (word and excel) on that PC and it
> failed.
> > You need to go to Tools/Reference in the VB-Editor and
> activate
> > references to these libraries :-)
> > Cindy Meister
> > INTER-Solutions, Switzerland
> > http://homepage.swissonline.ch/cindymeister
> > http://go.compuserve.com/MSWord
> > This reply is posted in the Newsgroup; please post any
> follow question
> > or reply in the newsgroup and not by e-mail :-)
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
|
|
mich
#5 / 18
|
Run-time error '424': Object required The answer even spammer gives.... "you will all notice me if I am in enough places." --
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote: > Do you know what's missing then? I only put it in other groups cause they > were VB related. Not everyone checks everygroup, so I usually have better > luck posting to several related groups to get the answer. > Thanks
> Jay
> Michael (michka) Kaplan
Quote:
> > Not for a CreateObject call, you don't? > > Do you think they could add any more irrelevant
newsgroups
> > to this thread? Sheesh. Whatever happened to focus?
> > --
> > MichKa
> > -------------------------------------
> > don't send questions by e-mail unless
> > you're paying for it. (TANSTAAFL!) :-)
> > random junk of dubious value and
> > replica error and problem fixing at:
> > http://www.trigeminal.com
wrote
> > > Hi Jay,
> > > > I tried CreateObject (word and excel) on that PC and
it
> > failed.
> > > You need to go to Tools/Reference in the VB-Editor and
> > activate
> > > references to these libraries :-)
> > > Cindy Meister
> > > INTER-Solutions, Switzerland
> > > http://homepage.swissonline.ch/cindymeister
> > > http://go.compuserve.com/MSWord
> > > This reply is posted in the Newsgroup; please post any
> > follow question
> > > or reply in the newsgroup and not by e-mail :-)
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
|
|
Neo
#6 / 18
|
Run-time error '424': Object required You might have to post the code to for us to see why it is going south but... This works.
Dim oWord as Object
Set oWord = CreateObject ("Word.Application")
oWord.Quit
If you just used:
Dim oWord
oWord = CreateOjbect("Word.Application")
oWord.Quit ' Generate the error
The you get the 424 run time error because you didn't use the Set key word.
--
Neo
[Trimmed down to 3 groups.]
: We have a standard build. My template works on other PCs. But having a
: problem on one with this message. Any ideas.
:
: I tried CreateObject (word and excel) on that PC and it failed.
:
: Jay
:
:
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
|
|
Jonathan Wes
#7 / 18
|
Run-time error '424': Object required Jay, Your habit of posting to a large number of groups does you no favours.
Various reasons.
1. Those who regularly read the groups that you post to, where the question
is not relevant, will soon mark you down as a nuisance, and generally avoid
troubling to answer you in future.
2. Those who regularly read groups will see the wide crosspost in the
header, and mark you down as a nuisance.
3. Because you are posting to so many groups, with quite a vague question, I
cannot for the life of me tell whether it is related to Word (my area) or
not. If you had restricted it to just a Word VBA group, I could then at
least have thought "well, lets ask for a bit more clarification, and then
see if we can help", and posted a reply accordingly. I'm not going to bother
if it turns out that you are really using Excel, Access, Outlook or VB6. Nor
am I very keen on questions and answers on those subjects cluttering up the
Word groups.
4. You cannot possiby have read the contents of all these groups. You are
therefore posting on the basis that they all contain the phrase "vb" or
something similar in them. This shows an unwillingness to make any attempt
at helping yourself, by finding the most relevant group, looking at the
subject of the posts, and seeing whether there is already an answer to a
similar question available. People answering questions in the groups are not
paid to do so, and they *really* appreciate questioners taking some effort
to help themselves.
A much more effective approach would be to select ONE newsgroup, whose
contents you have already read, so you know that the subject of the group is
relevant to your question, and post only there. If your question is
genuinely dealing with an interface between two products or technologies,
then it is reasonable to cross-post to a relevant group in both areas. If
you find yourself posting to more than (say) four groups, then you really
need to think hard about whether they are all truly relevant, and delete
some until you are down to four or less.
I suggest that you have a think about exactly what you are trying to
achieve, what applications, and then re-post a more clearly stated question,
to a smaller number of groups. You may find yourself pleasantly surprised by
the response.
Regards
Jonathan West - Word MVP
MultiLinker - Automated generation of hyperlinks in Word
Conversion to PDF & HTML
http://www.multilinker.com
Word FAQs at http://www.multilinker.com/wordfaq
Please post any follow-up in the newsgroup. I do not reply to Word questions
by email
Quote:
>Do you know what's missing then? I only put it in other groups cause they >were VB related. Not everyone checks everygroup, so I usually have better >luck posting to several related groups to get the answer. >Thanks
>Jay
>> Not for a CreateObject call, you don't?
>> Do you think they could add any more irrelevant newsgroups
>> to this thread? Sheesh. Whatever happened to focus?
>> --
>> MichKa
>> -------------------------------------
>> don't send questions by e-mail unless
>> you're paying for it. (TANSTAAFL!) :-)
>> random junk of dubious value and
>> replica error and problem fixing at:
>> http://www.trigeminal.com
>> > Hi Jay,
>> > > I tried CreateObject (word and excel) on that PC and it
>> failed.
>> > You need to go to Tools/Reference in the VB-Editor and
>> activate
>> > references to these libraries :-)
>> > Cindy Meister
>> > INTER-Solutions, Switzerland
>> > http://homepage.swissonline.ch/cindymeister
>> > http://go.compuserve.com/MSWord
>> > This reply is posted in the Newsgroup; please post any
>> follow question
>> > or reply in the newsgroup and not by e-mail :-)
|
| Mon, 18 Mar 2002 03:00:00 GMT |
|
|
|
Cindy Meister -WordMVP
#8 / 18
|
Run-time error '424': Object required Hi Michael, Quote: > Not for a CreateObject call, you don't?
If find I usually do need to, especially if I want to use the constants, such as wdCollapseEnd. Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://go.compuserve.com/MSWord
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
|
| Tue, 19 Mar 2002 03:00:00 GMT |
|
|
|
mich
#9 / 18
|
Run-time error '424': Object required Ok, you are confusing two different things here. You can dim variables as Object when calling CreateObject,
which makes for late bound objects... no reference required.
If you WANT those constants and to be early bound, then set
the reference. But that is an entirely different issue.
--
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote: > Hi Michael, > > Not for a CreateObject call, you don't?
> If find I usually do need to, especially if I want to use
the
> constants, such as wdCollapseEnd.
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister
> http://go.compuserve.com/MSWord
> This reply is posted in the Newsgroup; please post any
follow question
> or reply in the newsgroup and not by e-mail :-)
|
| Tue, 19 Mar 2002 03:00:00 GMT |
|
|
|
Cindy Meister -WordMVP
#10 / 18
|
Run-time error '424': Object required Hi Michael, And do you know how Jay has declared his object variable? I rather
expect it's been explicit as Word.Application, since he's getting this
error message. And then he does need a reference. So, what am I
confusing?
Quote: > You can dim variables as Object when calling CreateObject, > which makes for late bound objects... no reference required. > If you WANT those constants and to be early bound, then set
> the reference. But that is an entirely different issue.
Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister http://go.compuserve.com/MSWord This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
|
| Tue, 19 Mar 2002 03:00:00 GMT |
|
|
|
Andy Bar
#11 / 18
|
Run-time error '424': Object required If that were the case, he would have received a compile error (user-defined type not defined), not this runtime error. -- Andy
Quote: >Hi Michael, >And do you know how Jay has declared his object variable? I rather
>expect it's been explicit as Word.Application, since he's getting this
>error message. And then he does need a reference. So, what am I
>confusing?
>> You can dim variables as Object when calling CreateObject,
>> which makes for late bound objects... no reference required.
>> If you WANT those constants and to be early bound, then set
>> the reference. But that is an entirely different issue.
>Cindy Meister
>INTER-Solutions, Switzerland
>http://homepage.swissonline.ch/cindymeister
>http://go.compuserve.com/MSWord
>This reply is posted in the Newsgroup; please post any follow question
>or reply in the newsgroup and not by e-mail :-)
|
| Wed, 20 Mar 2002 03:00:00 GMT |
|
|
|
Cindy Meister -WordMVP
#12 / 18
|
Run-time error '424': Object required Hi Andy, Quote: > If that were the case, he would have received a compile error
> (user-defined type not defined), not this runtime error.
Right. I confused :-) Well, if Jay doesn't come back and offer more information...
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister
http://go.compuserve.com/MSWord
This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail :-)
|
| Wed, 20 Mar 2002 03:00:00 GMT |
|
|
|
mich
#13 / 18
|
Run-time error '424': Object required Personally, I think we should just let this thread die since the original poster was too lazy to target his response at all. One product is obviously being used but in the desperation to find an answer they have posted into multiple products and multiple newsgroups, with the only criteria that "programming" of some sort seem to be involved. USENET has a word for such behavior, it is called SPAM.
--
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote: > Hi Andy, > > If that were the case, he would have received a compile
error
> > (user-defined type not defined), not this runtime error.
> Right. I confused :-)
> Well, if Jay doesn't come back and offer more
information...
> Cindy Meister
> INTER-Solutions, Switzerland
> http://homepage.swissonline.ch/cindymeister
> http://go.compuserve.com/MSWord
> This reply is posted in the Newsgroup; please post any
follow question
> or reply in the newsgroup and not by e-mail :-)
|
| Wed, 20 Mar 2002 03:00:00 GMT |
|
|
|
Jay P. Parek
#14 / 18
|
Run-time error '424': Object required As I said in my other response, this is not only in Word, but VBA. I this error in Excel also. I cannot use CreateObject. Same 2 line code works on other machines without errors. Jay
Quote: > Personally, I think we should just let this thread die since > the original poster was too lazy to target his response at > all. One product is obviously being used but in the > desperation to find an answer they have posted into multiple > products and multiple newsgroups, with the only criteria > that "programming" of some sort seem to be involved. > USENET has a word for such behavior, it is called SPAM.
> --
> MichKa
> -------------------------------------
> don't send questions by e-mail unless
> you're paying for it. (TANSTAAFL!) :-)
> random junk of dubious value and
> replica error and problem fixing at:
> http://www.trigeminal.com
> > Hi Andy,
> > > If that were the case, he would have received a compile
> error
> > > (user-defined type not defined), not this runtime error.
> > Right. I confused :-)
> > Well, if Jay doesn't come back and offer more
> information...
> > Cindy Meister
> > INTER-Solutions, Switzerland
> > http://homepage.swissonline.ch/cindymeister
> > http://go.compuserve.com/MSWord
> > This reply is posted in the Newsgroup; please post any
> follow question
> > or reply in the newsgroup and not by e-mail :-)
|
| Wed, 20 Mar 2002 03:00:00 GMT |
|
|
|
mich
#15 / 18
|
Run-time error '424': Object required And if there is an error such as this, you need to spam every damn group like this? Why not try a little focus? Never mind, I'm tired of this.
<PLONK>
--
MichKa
-------------------------------------
don't send questions by e-mail unless
you're paying for it. (TANSTAAFL!) :-)
random junk of dubious value and
replica error and problem fixing at:
http://www.trigeminal.com
Quote: > As I said in my other response, this is not only in Word, but VBA. I this > error in Excel also. I cannot use CreateObject. Same 2 line code works on > other machines without errors. > Jay
> Michael (michka) Kaplan
Quote:
> > Personally, I think we should just let this thread die since > > the original poster was too lazy to target his response at > > all. One product is obviously being used but in the > > desperation to find an answer they have posted into multiple > > products and multiple newsgroups, with the only criteria > > that "programming" of some sort seem to be involved. > > USENET has a word for such behavior, it is called SPAM.
> > --
> > MichKa
> > -------------------------------------
> > don't send questions by e-mail unless
> > you're paying for it. (TANSTAAFL!) :-)
> > random junk of dubious value and
> > replica error and problem fixing at:
> > http://www.trigeminal.com
wrote
> > > Hi Andy,
> > > > If that were the case, he would have received a
compile
> > error
> > > > (user-defined type not defined), not this runtime
error.
> > > Right. I confused :-)
> > > Well, if Jay doesn't come back and offer more
> > information...
> > > Cindy Meister
> > > INTER-Solutions, Switzerland
> > > http://homepage.swissonline.ch/cindymeister
> > > http://go.compuserve.com/MSWord
> > > This reply is posted in the Newsgroup; please post any
> > follow question
> > > or reply in the newsgroup and not by e-mail :-)
|
| Wed, 20 Mar 2002 03:00:00 GMT |
|
| |
Page 1 of 2
|
[ 18 post ] |
|
Go to page:
[1]
[2] |
|
