In a PowerBuilder script, this line of code works fine in Word 9.0 (Office
2000). But it fails in Word 11.0 (Office 2003).

ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,TRUE,FALSE,FALSE,"","",FALSE,"","","Enti re
Spreadsheet")

The error is "Error 35 - Error calling external object function
OpenDataSource at line 52"

Two new parameters have been added in Word 11, [I found a 2003 thread in
this forum which suggesteed that the values should be as follows. This does
not work for me, but I'm working with Word 11, and the author of the 2003
thread was working with "Word 2002" - probably Office 2002? - don't know
what version, but probably 10. Should I be entering a different constant
value for the last parameter?

ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,
TRUE,FALSE,FALSE,"","",FALSE,"","","Entire
Spreadsheet",FALSE,8)

Note that I have no experience working with OLE, so please use "for dummies"
language when responding.

TIA
LAS

Please continue this as necessary in the microsoft.public.word.vba.general
newsgroup.

Peter Jamieson

"Laurel" wrote in message
...
In a PowerBuilder script, this line of code works fine in Word 9.0
(Office 2000). But it fails in Word 11.0 (Office 2003).


ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,TRUE,FALSE,FALSE,"","",FALSE,"","","Enti re
Spreadsheet")

The error is "Error 35 - Error calling external object function
OpenDataSource at line 52"

Two new parameters have been added in Word 11, [I found a 2003 thread in
this forum which suggesteed that the values should be as follows. This
does not work for me, but I'm working with Word 11, and the author of the
2003 thread was working with "Word 2002" - probably Office 2002? - don't
know what version, but probably 10. Should I be entering a different
constant value for the last parameter?

ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,
TRUE,FALSE,FALSE,"","",FALSE,"","","Entire
Spreadsheet",FALSE,8)

Note that I have no experience working with OLE, so please use "for
dummies" language when responding.

TIA
LAS

OK, have reposted in that forum. Since you were actually the person who
responded to the posting in 2003 that led me here, perhaps you could take a
look?
The subject is
"OpenDataSource Fails - Reposted from another forum"
tia
las


"Peter Jamieson" wrote in message
...
Please continue this as necessary in the microsoft.public.word.vba.general
newsgroup.

Peter Jamieson

"Laurel" wrote in message
...
In a PowerBuilder script, this line of code works fine in Word 9.0
(Office 2000). But it fails in Word 11.0 (Office 2003).


ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,TRUE,FALSE,FALSE,"","",FALSE,"","","Enti re
Spreadsheet")

The error is "Error 35 - Error calling external object function
OpenDataSource at line 52"

Two new parameters have been added in Word 11, [I found a 2003 thread in
this forum which suggesteed that the values should be as follows. This
does not work for me, but I'm working with Word 11, and the author of the
2003 thread was working with "Word 2002" - probably Office 2002? - don't
know what version, but probably 10. Should I be entering a different
constant value for the last parameter?

ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,
TRUE,FALSE,FALSE,"","",FALSE,"","","Entire
Spreadsheet",FALSE,8)

Note that I have no experience working with OLE, so please use "for
dummies" language when responding.

TIA
LAS

I already did, I think.

Peter Jamieson


"Laurel" wrote in message
...
OK, have reposted in that forum. Since you were actually the person who
responded to the posting in 2003 that led me here, perhaps you could take
a look?
The subject is
"OpenDataSource Fails - Reposted from another forum"
tia
las


"Peter Jamieson" wrote in message
...
Please continue this as necessary in the
microsoft.public.word.vba.general newsgroup.

Peter Jamieson

"Laurel" wrote in message
...
In a PowerBuilder script, this line of code works fine in Word 9.0
(Office 2000). But it fails in Word 11.0 (Office 2003).


ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,TRUE,FALSE,FALSE,"","",FALSE,"","","Enti re
Spreadsheet")

The error is "Error 35 - Error calling external object function
OpenDataSource at line 52"

Two new parameters have been added in Word 11, [I found a 2003 thread in
this forum which suggesteed that the values should be as follows. This
does not work for me, but I'm working with Word 11, and the author of
the 2003 thread was working with "Word 2002" - probably Office 2002? -
don't know what version, but probably 10. Should I be entering a
different constant value for the last parameter?

ole_word_file.MailMerge.OpenDataSource(is_excel_do c,0,FALSE,
TRUE,FALSE,FALSE,"","",FALSE,"","","Entire
Spreadsheet",FALSE,8)

Note that I have no experience working with OLE, so please use "for
dummies" language when responding.

TIA
LAS