Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

problem with macro when upgrading from 2002 to 2003

1 view
Skip to first unread message

bowlfr...@yahoo.com

unread,
Feb 22, 2008, 10:55:30 AM2/22/08
to
One of my users has an Excel spreadsheet that is used as a data source
for Word. He was recently upgraded from Office 2002 to 2003. When he
runs the macro to print from Excel to Word he is receiving the
following error: Run-time Error '5922' Word was unable to open the
data source. Here's the line it's choking on:

.ActiveDocument.MailMerge.OpenDataSource Name:= _
"G:\Capital Projects\Invoice Cover Sheets\Current
Projects\Engineering\Payment Management Eng.xls" _
, ConfirmConversions:=False, ReadOnly:=False,
LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="",
PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="",
Revert:=False, _
Format:=wdOpenFormatAuto, Connection:= _
"Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User
ID=Admin;Data Source=G:\Capital Projects\Invoice Cover Sheets\Current
Projects\Engineering\Payment Management ENG.xls;Mode=Read;Extended
Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet
OLEDB:" _
, SQLStatement:="SELECT * FROM `'Monthly Payment$'`
WHERE `Payment Due` <> 0", SQLStatement1:="", _
SubType:=wdMergeSubTypeAccess

Any help would be greatly appreciated. Thank you.

0 new messages