Access Word 2003 Automation

[Cheval]

Has anyone had any problems with inter-office automation between MS Word and
MS Access in Office 2003?

I have recently installed office 2003 in a new folder and have left the
older office 2000 and office XP components installed. ie I have
word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k to
word 2k automation yet I get the error "Automation Error" "ClassFacto ry
cannot supply requested class" when on late binding try to create the Word
object or on early binding when I try to use the object. So thinking it is a
new office install problem I tried with Access 2003 and Word 2003 and the
same problem. BTW I have selected Word 11.0 Object Library in the references
both times.

So does anyone have any ideas?

[TC]

Re: Access Word 2003 Automation

Show us the code that you use to instantiate Word.

TC



"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=blue]
> Has anyone had any problems with inter-office automation between MS Word[/color]
and[color=blue]
> MS Access in Office 2003?
>
> I have recently installed office 2003 in a new folder and have left the
> older office 2000 and office XP components installed. ie I have
> word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k to
> word 2k automation yet I get the error "Automation Error" "ClassFacto ry
> cannot supply requested class" when on late binding try to create the Word
> object or on early binding when I try to use the object. So thinking it is[/color]
a[color=blue]
> new office install problem I tried with Access 2003 and Word 2003 and the
> same problem. BTW I have selected Word 11.0 Object Library in the[/color]
references[color=blue]
> both times.
>
> So does anyone have any ideas?
>
>[/color]

[Cheval]

Re: Access Word 2003 Automation

Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("W ord.Application ")
oApp.Visible = True
[color=blue][color=green][color=darkred]
>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color][/color]

"TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
Show us the code that you use to instantiate Word.

TC



"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=blue]
> Has anyone had any problems with inter-office automation between MS Word[/color]
and[color=blue]
> MS Access in Office 2003?
>
> I have recently installed office 2003 in a new folder and have left the
> older office 2000 and office XP components installed. ie I have
> word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k to
> word 2k automation yet I get the error "Automation Error" "ClassFacto ry
> cannot supply requested class" when on late binding try to create the Word
> object or on early binding when I try to use the object. So thinking it is[/color]
a[color=blue]
> new office install problem I tried with Access 2003 and Word 2003 and the
> same problem. BTW I have selected Word 11.0 Object Library in the[/color]
references[color=blue]
> both times.
>
> So does anyone have any ideas?
>
>[/color]

[TC]

Re: Access Word 2003 Automation

Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
Perhaps you need to re-register Word? (regsvr32)

HTH,
TC



"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=blue]
> Sure, here it is. Simple boiler plate code...
>
> Dim oApp As Object
>
> Set oApp = CreateObject("W ord.Application ")
> oApp.Visible = True
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> Show us the code that you use to instantiate Word.
>
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=green]
> > Has anyone had any problems with inter-office automation between MS Word[/color]
> and[color=green]
> > MS Access in Office 2003?
> >
> > I have recently installed office 2003 in a new folder and have left the
> > older office 2000 and office XP components installed. ie I have
> > word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k[/color][/color]
to[color=blue][color=green]
> > word 2k automation yet I get the error "Automation Error" "ClassFacto ry
> > cannot supply requested class" when on late binding try to create the[/color][/color]
Word[color=blue][color=green]
> > object or on early binding when I try to use the object. So thinking it[/color][/color]
is[color=blue]
> a[color=green]
> > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
the[color=blue][color=green]
> > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> references[color=green]
> > both times.
> >
> > So does anyone have any ideas?
> >
> >[/color]
>
>
>[/color]

[Cheval]

Re: Access Word 2003 Automation

Sorry about the delay.

Yeah I know, nothing extrordinary at all, just yet. Excel ran fine and I
tried the "repair" feature of Office 2003, yet that didn't help.

Which component would I try re-registrying?
[color=blue][color=green][color=darkred]
>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color][/color]

"TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
Perhaps you need to re-register Word? (regsvr32)

HTH,
TC



"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=blue]
> Sure, here it is. Simple boiler plate code...
>
> Dim oApp As Object
>
> Set oApp = CreateObject("W ord.Application ")
> oApp.Visible = True
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> Show us the code that you use to instantiate Word.
>
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=green]
> > Has anyone had any problems with inter-office automation between MS Word[/color]
> and[color=green]
> > MS Access in Office 2003?
> >
> > I have recently installed office 2003 in a new folder and have left the
> > older office 2000 and office XP components installed. ie I have
> > word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k[/color][/color]
to[color=blue][color=green]
> > word 2k automation yet I get the error "Automation Error" "ClassFacto ry
> > cannot supply requested class" when on late binding try to create the[/color][/color]
Word[color=blue][color=green]
> > object or on early binding when I try to use the object. So thinking it[/color][/color]
is[color=blue]
> a[color=green]
> > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
the[color=blue][color=green]
> > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> references[color=green]
> > both times.
> >
> > So does anyone have any ideas?
> >
> >[/color]
>
>
>[/color]

[Cheval]

Re: Access Word 2003 Automation

I've even tried from the command line "C:\Program Files\Microsoft Office
2003\OFFICE11\W inWord.exe" /r
to re-register Word, yet still the same error...?

??????????????? ??????????????? ??????????????? ??????????????? ?????

"TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
Perhaps you need to re-register Word? (regsvr32)

HTH,
TC



"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=blue]
> Sure, here it is. Simple boiler plate code...
>
> Dim oApp As Object
>
> Set oApp = CreateObject("W ord.Application ")
> oApp.Visible = True
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> Show us the code that you use to instantiate Word.
>
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=green]
> > Has anyone had any problems with inter-office automation between MS Word[/color]
> and[color=green]
> > MS Access in Office 2003?
> >
> > I have recently installed office 2003 in a new folder and have left the
> > older office 2000 and office XP components installed. ie I have
> > word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k[/color][/color]
to[color=blue][color=green]
> > word 2k automation yet I get the error "Automation Error" "ClassFacto ry
> > cannot supply requested class" when on late binding try to create the[/color][/color]
Word[color=blue][color=green]
> > object or on early binding when I try to use the object. So thinking it[/color][/color]
is[color=blue]
> a[color=green]
> > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
the[color=blue][color=green]
> > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> references[color=green]
> > both times.
> >
> > So does anyone have any ideas?
> >
> >[/color]
>
>
>[/color]

[TC]

Re: Access Word 2003 Automation


"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:7xJFb.6198 0$aT.14525@news-server.bigpond. net.au...[color=blue]
> Sorry about the delay.
>
> Yeah I know, nothing extrordinary at all, just yet. Excel ran fine and I
> tried the "repair" feature of Office 2003, yet that didn't help.
>
> Which component would I try re-registrying?[/color]

Good question! To be honest, I am not really sure. Re-registering something
seems to be a general solution for various automation problems. Perhaps try
going to the command line, moving to the directory containing msword.exe (or
whatever the exe is called), and typing: "msword -unregserver" then
msword -regserver" or similar? (Certain executables will unregister &
re-register themselves if you give them suitable arguments, like those. You
may need to do some searching to confirm that those are the right arguments
for ms word.)

My guess is that it is something to do with having different versions of
word on the PC. Perhaps try calling a specified version? (eg.
Word.Applicatio n.8 for Word 97, Word.Applicatio n.9 for word 2k, etc.).

HTH,
TC

[color=blue]
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
> Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
> Perhaps you need to re-register Word? (regsvr32)
>
> HTH,
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=green]
> > Sure, here it is. Simple boiler plate code...
> >
> > Dim oApp As Object
> >
> > Set oApp = CreateObject("W ord.Application ")
> > oApp.Visible = True
> >[color=darkred]
> > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color]
> >
> > "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> > Show us the code that you use to instantiate Word.
> >
> > TC
> >
> >
> >
> > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=darkred]
> > > Has anyone had any problems with inter-office automation between MS[/color][/color][/color]
Word[color=blue][color=green]
> > and[color=darkred]
> > > MS Access in Office 2003?
> > >
> > > I have recently installed office 2003 in a new folder and have left[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > older office 2000 and office XP components installed. ie I have
> > > word/access/excel 2k/xp/2003 installed. I tried to do a usual access[/color][/color][/color]
2k[color=blue]
> to[color=green][color=darkred]
> > > word 2k automation yet I get the error "Automation Error"[/color][/color][/color]
"ClassFacto ry[color=blue][color=green][color=darkred]
> > > cannot supply requested class" when on late binding try to create the[/color][/color]
> Word[color=green][color=darkred]
> > > object or on early binding when I try to use the object. So thinking[/color][/color][/color]
it[color=blue]
> is[color=green]
> > a[color=darkred]
> > > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
> the[color=green][color=darkred]
> > > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> > references[color=darkred]
> > > both times.
> > >
> > > So does anyone have any ideas?
> > >
> > >[/color]
> >
> >
> >[/color]
>
>
>[/color]

[TC]

Re: Access Word 2003 Automation

Ok, just read this after posting my other reply. Are you sure that /r is the
right argument?

TC


"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:uUJFb.6199 8$aT.4765@news-server.bigpond. net.au...[color=blue]
> I've even tried from the command line "C:\Program Files\Microsoft Office
> 2003\OFFICE11\W inWord.exe" /r
> to re-register Word, yet still the same error...?
>
> ??????????????? ??????????????? ??????????????? ??????????????? ?????
>
> "TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
> Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
> Perhaps you need to re-register Word? (regsvr32)
>
> HTH,
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=green]
> > Sure, here it is. Simple boiler plate code...
> >
> > Dim oApp As Object
> >
> > Set oApp = CreateObject("W ord.Application ")
> > oApp.Visible = True
> >[color=darkred]
> > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color]
> >
> > "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> > Show us the code that you use to instantiate Word.
> >
> > TC
> >
> >
> >
> > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=darkred]
> > > Has anyone had any problems with inter-office automation between MS[/color][/color][/color]
Word[color=blue][color=green]
> > and[color=darkred]
> > > MS Access in Office 2003?
> > >
> > > I have recently installed office 2003 in a new folder and have left[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > older office 2000 and office XP components installed. ie I have
> > > word/access/excel 2k/xp/2003 installed. I tried to do a usual access[/color][/color][/color]
2k[color=blue]
> to[color=green][color=darkred]
> > > word 2k automation yet I get the error "Automation Error"[/color][/color][/color]
"ClassFacto ry[color=blue][color=green][color=darkred]
> > > cannot supply requested class" when on late binding try to create the[/color][/color]
> Word[color=green][color=darkred]
> > > object or on early binding when I try to use the object. So thinking[/color][/color][/color]
it[color=blue]
> is[color=green]
> > a[color=darkred]
> > > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
> the[color=green][color=darkred]
> > > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> > references[color=darkred]
> > > both times.
> > >
> > > So does anyone have any ideas?
> > >
> > >[/color]
> >
> >
> >[/color]
>
>
>[/color]

[Cheval]

Re: Access Word 2003 Automation

Yeah. See the article

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q210/5/65.ASP&NoWebContent=1

I've even tried re-registrering the word type library "regtlib.ex e
msword.olb" to no success... :(
[color=blue][color=green][color=darkred]
>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>[/color][/color][/color]

"TC" <a@b.c.d> wrote in message news:1072148911 .85202@teuthos. ..
Ok, just read this after posting my other reply. Are you sure that /r is the
right argument?

TC


"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:uUJFb.6199 8$aT.4765@news-server.bigpond. net.au...[color=blue]
> I've even tried from the command line "C:\Program Files\Microsoft Office
> 2003\OFFICE11\W inWord.exe" /r
> to re-register Word, yet still the same error...?
>
> ??????????????? ??????????????? ??????????????? ??????????????? ?????
>
> "TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
> Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
> Perhaps you need to re-register Word? (regsvr32)
>
> HTH,
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=green]
> > Sure, here it is. Simple boiler plate code...
> >
> > Dim oApp As Object
> >
> > Set oApp = CreateObject("W ord.Application ")
> > oApp.Visible = True
> >[color=darkred]
> > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color]
> >
> > "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> > Show us the code that you use to instantiate Word.
> >
> > TC
> >
> >
> >
> > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=darkred]
> > > Has anyone had any problems with inter-office automation between MS[/color][/color][/color]
Word[color=blue][color=green]
> > and[color=darkred]
> > > MS Access in Office 2003?
> > >
> > > I have recently installed office 2003 in a new folder and have left[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > older office 2000 and office XP components installed. ie I have
> > > word/access/excel 2k/xp/2003 installed. I tried to do a usual access[/color][/color][/color]
2k[color=blue]
> to[color=green][color=darkred]
> > > word 2k automation yet I get the error "Automation Error"[/color][/color][/color]
"ClassFacto ry[color=blue][color=green][color=darkred]
> > > cannot supply requested class" when on late binding try to create the[/color][/color]
> Word[color=green][color=darkred]
> > > object or on early binding when I try to use the object. So thinking[/color][/color][/color]
it[color=blue]
> is[color=green]
> > a[color=darkred]
> > > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
> the[color=green][color=darkred]
> > > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> > references[color=darkred]
> > > both times.
> > >
> > > So does anyone have any ideas?
> > >
> > >[/color]
> >
> >
> >[/color]
>
>
>[/color]

[Cheval]

Re: Access Word 2003 Automation

ok. I tried that yet no luck. I'm out of ideas, so thanks again for your
help.
[color=blue][color=green][color=darkred]
>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color][/color]

"TC" <a@b.c.d> wrote in message news:1072148866 .849683@teuthos ...

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:7xJFb.6198 0$aT.14525@news-server.bigpond. net.au...[color=blue]
> Sorry about the delay.
>
> Yeah I know, nothing extrordinary at all, just yet. Excel ran fine and I
> tried the "repair" feature of Office 2003, yet that didn't help.
>
> Which component would I try re-registrying?[/color]

Good question! To be honest, I am not really sure. Re-registering something
seems to be a general solution for various automation problems. Perhaps try
going to the command line, moving to the directory containing msword.exe (or
whatever the exe is called), and typing: "msword -unregserver" then
msword -regserver" or similar? (Certain executables will unregister &
re-register themselves if you give them suitable arguments, like those. You
may need to do some searching to confirm that those are the right arguments
for ms word.)

My guess is that it is something to do with having different versions of
word on the PC. Perhaps try calling a specified version? (eg.
Word.Applicatio n.8 for Word 97, Word.Applicatio n.9 for word 2k, etc.).

HTH,
TC

[color=blue]
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
> Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
> Perhaps you need to re-register Word? (regsvr32)
>
> HTH,
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=green]
> > Sure, here it is. Simple boiler plate code...
> >
> > Dim oApp As Object
> >
> > Set oApp = CreateObject("W ord.Application ")
> > oApp.Visible = True
> >[color=darkred]
> > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color]
> >
> > "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> > Show us the code that you use to instantiate Word.
> >
> > TC
> >
> >
> >
> > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=darkred]
> > > Has anyone had any problems with inter-office automation between MS[/color][/color][/color]
Word[color=blue][color=green]
> > and[color=darkred]
> > > MS Access in Office 2003?
> > >
> > > I have recently installed office 2003 in a new folder and have left[/color][/color][/color]
the[color=blue][color=green][color=darkred]
> > > older office 2000 and office XP components installed. ie I have
> > > word/access/excel 2k/xp/2003 installed. I tried to do a usual access[/color][/color][/color]
2k[color=blue]
> to[color=green][color=darkred]
> > > word 2k automation yet I get the error "Automation Error"[/color][/color][/color]
"ClassFacto ry[color=blue][color=green][color=darkred]
> > > cannot supply requested class" when on late binding try to create the[/color][/color]
> Word[color=green][color=darkred]
> > > object or on early binding when I try to use the object. So thinking[/color][/color][/color]
it[color=blue]
> is[color=green]
> > a[color=darkred]
> > > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
> the[color=green][color=darkred]
> > > same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> > references[color=darkred]
> > > both times.
> > >
> > > So does anyone have any ideas?
> > >
> > >[/color]
> >
> >
> >[/color]
>
>
>[/color]

[TC]

Re: Access Word 2003 Automation

Sorry cheval - I'm out of ideas. Hope you get it sorted somehow. Perhaps try
in a Word newsgroup? It is to do with automating Word, so they might have
the answer.

HTH,
TC


"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:M%1Gb.6313 7$aT.42680@news-server.bigpond. net.au...[color=blue]
> ok. I tried that yet no luck. I'm out of ideas, so thanks again for your
> help.
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1072148866 .849683@teuthos ...
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:7xJFb.6198 0$aT.14525@news-server.bigpond. net.au...[color=green]
> > Sorry about the delay.
> >
> > Yeah I know, nothing extrordinary at all, just yet. Excel ran fine and I
> > tried the "repair" feature of Office 2003, yet that didn't help.
> >
> > Which component would I try re-registrying?[/color]
>
> Good question! To be honest, I am not really sure. Re-registering[/color]
something[color=blue]
> seems to be a general solution for various automation problems. Perhaps[/color]
try[color=blue]
> going to the command line, moving to the directory containing msword.exe[/color]
(or[color=blue]
> whatever the exe is called), and typing: "msword -unregserver" then
> msword -regserver" or similar? (Certain executables will unregister &
> re-register themselves if you give them suitable arguments, like those.[/color]
You[color=blue]
> may need to do some searching to confirm that those are the right[/color]
arguments[color=blue]
> for ms word.)
>
> My guess is that it is something to do with having different versions of
> word on the PC. Perhaps try calling a specified version? (eg.
> Word.Applicatio n.8 for Word 97, Word.Applicatio n.9 for word 2k, etc.).
>
> HTH,
> TC
>
>[color=green]
> >[color=darkred]
> > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>[/color]
> >
> > "TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
> > Looks ok to me. Does it fail with other objects (eg. Excel), or just[/color][/color]
Word?[color=blue][color=green]
> > Perhaps you need to re-register Word? (regsvr32)
> >
> > HTH,
> > TC
> >
> >
> >
> > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=darkred]
> > > Sure, here it is. Simple boiler plate code...
> > >
> > > Dim oApp As Object
> > >
> > > Set oApp = CreateObject("W ord.Application ")
> > > oApp.Visible = True
> > >
> > > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>
> > >
> > > "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> > > Show us the code that you use to instantiate Word.
> > >
> > > TC
> > >
> > >
> > >
> > > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > > news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...
> > > > Has anyone had any problems with inter-office automation between MS[/color][/color]
> Word[color=green][color=darkred]
> > > and
> > > > MS Access in Office 2003?
> > > >
> > > > I have recently installed office 2003 in a new folder and have left[/color][/color]
> the[color=green][color=darkred]
> > > > older office 2000 and office XP components installed. ie I have
> > > > word/access/excel 2k/xp/2003 installed. I tried to do a usual access[/color][/color]
> 2k[color=green]
> > to[color=darkred]
> > > > word 2k automation yet I get the error "Automation Error"[/color][/color]
> "ClassFacto ry[color=green][color=darkred]
> > > > cannot supply requested class" when on late binding try to create[/color][/color][/color]
the[color=blue][color=green]
> > Word[color=darkred]
> > > > object or on early binding when I try to use the object. So thinking[/color][/color]
> it[color=green]
> > is[color=darkred]
> > > a
> > > > new office install problem I tried with Access 2003 and Word 2003[/color][/color][/color]
and[color=blue][color=green]
> > the[color=darkred]
> > > > same problem. BTW I have selected Word 11.0 Object Library in the
> > > references
> > > > both times.
> > > >
> > > > So does anyone have any ideas?
> > > >
> > > >
> > >
> > >
> > >[/color]
> >
> >
> >[/color]
>
>
>[/color]

[Samuel Hon]

Re: Access Word 2003 Automation

Hi

Maybe your registry has a few gremlins in it. Download RegClean and
run it a couple of times tills it comes up with no errors

Then try your code. If it still doesnt work, register Word again

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message news:<tW1Gb.631 35$aT.53951@new s-server.bigpond. net.au>...[color=blue]
> Yeah. See the article
> http://support.microsoft.com/default...NoWebContent=1
> I've even tried re-registrering the word type library "regtlib.ex e
> msword.olb" to no success... :(
>[color=green][color=darkred]
> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1072148911 .85202@teuthos. ..
> Ok, just read this after posting my other reply. Are you sure that /r is the
> right argument?
>
> TC
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:uUJFb.6199 8$aT.4765@news-server.bigpond. net.au...[color=green]
> > I've even tried from the command line "C:\Program Files\Microsoft Office
> > 2003\OFFICE11\W inWord.exe" /r
> > to re-register Word, yet still the same error...?
> >
> > ??????????????? ??????????????? ??????????????? ??????????????? ?????
> >
> > "TC" <a@b.c.d> wrote in message news:1071877362 .162009@teuthos ...
> > Looks ok to me. Does it fail with other objects (eg. Excel), or just Word?
> > Perhaps you need to re-register Word? (regsvr32)
> >
> > HTH,
> > TC
> >
> >
> >
> > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au...[color=darkred]
> > > Sure, here it is. Simple boiler plate code...
> > >
> > > Dim oApp As Object
> > >
> > > Set oApp = CreateObject("W ord.Application ")
> > > oApp.Visible = True
> > >
> > > >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>
> > >
> > > "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> > > Show us the code that you use to instantiate Word.
> > >
> > > TC
> > >
> > >
> > >
> > > "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> > > news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...
> > > > Has anyone had any problems with inter-office automation between MS[/color][/color]
> Word
> and[color=green][color=darkred]
> > > > MS Access in Office 2003?
> > > >
> > > > I have recently installed office 2003 in a new folder and have left[/color][/color]
> the[color=green][color=darkred]
> > > > older office 2000 and office XP components installed. ie I have
> > > > word/access/excel 2k/xp/2003 installed. I tried to do a usual access[/color][/color]
> 2k
> to[color=green][color=darkred]
> > > > word 2k automation yet I get the error "Automation Error"[/color][/color]
> "ClassFacto ry[color=green][color=darkred]
> > > > cannot supply requested class" when on late binding try to create the[/color][/color]
> Word[color=green][color=darkred]
> > > > object or on early binding when I try to use the object. So thinking[/color][/color]
> it
> is
> a[color=green][color=darkred]
> > > > new office install problem I tried with Access 2003 and Word 2003 and[/color][/color]
> the[color=green][color=darkred]
> > > > same problem. BTW I have selected Word 11.0 Object Library in the[/color][/color]
> references[color=green][color=darkred]
> > > > both times.
> > > >
> > > > So does anyone have any ideas?
> > > >
> > > >
> > >
> > >
> > >[/color]
> >
> >
> >[/color][/color]

[Lyle Fairfield]

Re: Access Word 2003 Automation

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in
news:IaLEb.5863 9$aT.6057@news-server.bigpond. net.au:
[color=blue]
> Sure, here it is. Simple boiler plate code...
>
> Dim oApp As Object
>
> Set oApp = CreateObject("W ord.Application ")
> oApp.Visible = True
>[color=green][color=darkred]
>>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>>>>>>>>>> >>>>>>[/color][/color]
>
> "TC" <a@b.c.d> wrote in message news:1071811700 .757201@teuthos ...
> Show us the code that you use to instantiate Word.
>
> TC
>
>
>
> "Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
> news:CSvEb.5795 9$aT.56015@news-server.bigpond. net.au...[color=green]
>> Has anyone had any problems with inter-office automation between MS
>> Word[/color]
> and[color=green]
>> MS Access in Office 2003?
>>
>> I have recently installed office 2003 in a new folder and have left the
>> older office 2000 and office XP components installed. ie I have
>> word/access/excel 2k/xp/2003 installed. I tried to do a usual access 2k
>> to word 2k automation yet I get the error "Automation Error"
>> "ClassFacto ry cannot supply requested class" when on late binding try
>> to create the Word object or on early binding when I try to use the
>> object. So thinking it is[/color]
> a[color=green]
>> new office install problem I tried with Access 2003 and Word 2003 and
>> the same problem. BTW I have selected Word 11.0 Object Library in the[/color]
> references[color=green]
>> both times.
>>
>> So does anyone have any ideas?[/color][/color]

Well, I've always found automating Word to be gnarly. So I have found
other ways to accomplish what I want to accomplish. For printing documents
that use Jet records for field filling in Word, I have found that writing
a text file from Access, and opening a Word Document (through a hyperlink?
.... can't remember) that is defaulted to using that text file for getting
field values, was much less error prone, and much faster than using
automation. And of course, the Word Document can have On Open Event code
that can do things that may need to be done. This may not be what you want
to do. And of course, somewhere, sometime I wrote code to find and close
all instances of Word.

Ten years ago Word Perfect and Quattro Pro were quite superior to Word and
Excel; I think Quattro Pro 4 ??? of that vintage is still superior to the
Excel of today. If God is going to punish MS for something, he/she could
choose using their marketing and financial might to move the world to
these two really crappy applications ... Or not making the whole range of
API functions available to software competitors ... Or ... etc, etc.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)