By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,657 Members | 774 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,657 IT Pros & Developers. It's quick & easy.

Access Word 2003 Automation

P: n/a
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" "ClassFactory
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?
Nov 12 '05 #1
Share this Question
Share on Google+
12 Replies


P: n/a
TC
Show us the code that you use to instantiate Word.

TC

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:CS******************@news-server.bigpond.net.au...
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" "ClassFactory
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?

Nov 12 '05 #2

P: n/a
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au... 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" "ClassFactory
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?


Nov 12 '05 #3

P: n/a
TC
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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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" "ClassFactory
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?


Nov 12 '05 #4

P: n/a
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?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>

"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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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" "ClassFactory
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?



Nov 12 '05 #5

P: n/a
I've even tried from the command line "C:\Program Files\Microsoft Office
2003\OFFICE11\WinWord.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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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" "ClassFactory
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?



Nov 12 '05 #6

P: n/a
TC

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:7x******************@news-server.bigpond.net.au...
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?
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.Application.8 for Word 97, Word.Application.9 for word 2k, etc.).

HTH,
TC

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>
"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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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"
"ClassFactory 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?



Nov 12 '05 #7

P: n/a
TC
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:uU*****************@news-server.bigpond.net.au...
I've even tried from the command line "C:\Program Files\Microsoft Office
2003\OFFICE11\WinWord.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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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"
"ClassFactory 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?



Nov 12 '05 #8

P: n/a
Yeah. See the article
http://support.microsoft.com/default...NoWebContent=1
I've even tried re-registrering the word type library "regtlib.exe
msword.olb" to no success... :(
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
"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:uU*****************@news-server.bigpond.net.au...
I've even tried from the command line "C:\Program Files\Microsoft Office
2003\OFFICE11\WinWord.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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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"
"ClassFactory 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?




Nov 12 '05 #9

P: n/a
ok. I tried that yet no luck. I'm out of ideas, so thanks again for your
help.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>
"TC" <a@b.c.d> wrote in message news:1072148866.849683@teuthos...

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:7x******************@news-server.bigpond.net.au...
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?
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.Application.8 for Word 97, Word.Application.9 for word 2k, etc.).

HTH,
TC

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>
"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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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"
"ClassFactory 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?




Nov 12 '05 #10

P: n/a
TC
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%******************@news-server.bigpond.net.au...
ok. I tried that yet no luck. I'm out of ideas, so thanks again for your
help.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>
"TC" <a@b.c.d> wrote in message news:1072148866.849683@teuthos...

"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in message
news:7x******************@news-server.bigpond.net.au...
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?
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.Application.8 for Word 97, Word.Application.9 for word 2k, etc.).

HTH,
TC

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >>


"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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
> 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"

"ClassFactory > 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?
>
>



Nov 12 '05 #11

P: n/a
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:<tW******************@news-server.bigpond.net.au>...
Yeah. See the article
http://support.microsoft.com/default...NoWebContent=1
I've even tried re-registrering the word type library "regtlib.exe
msword.olb" to no success... :(
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
"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:uU*****************@news-server.bigpond.net.au...
I've even tried from the command line "C:\Program Files\Microsoft Office
2003\OFFICE11\WinWord.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:Ia*****************@news-server.bigpond.net.au...
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
> 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" "ClassFactory > 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?
>
>


Nov 12 '05 #12

P: n/a
"Cheval" <n2cheval@[NotSo]hotmail.com> wrote in
news:Ia*****************@news-server.bigpond.net.au:
Sure, here it is. Simple boiler plate code...

Dim oApp As Object

Set oApp = CreateObject("Word.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:CS******************@news-server.bigpond.net.au...
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"
"ClassFactory 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?


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)
Nov 12 '05 #13

This discussion thread is closed

Replies have been disabled for this discussion.