Dim strTemp1 As String
Dim strTemp2 As String
Dim strTemp3 As String
strTemp1 = App.Path & "\templates\tempXJ.xls"
strTemp2 = "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=" & strTemp1 & ";Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine T"
With WordApp.ActiveDocument.MailMerge
.MainDocumentType = wdFormLetters
.OpenDataSource strTemp1, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=0, Connection:=strTemp2 _
, SQLStatement:="SELECT * FROM `Sheet1$`", SQLStatement1:="", SubType:=1打包后运行提示“字符串多于255个字符”。但是在设计环境下运行正常
Dim strTemp2 As String
Dim strTemp3 As String
strTemp1 = App.Path & "\templates\tempXJ.xls"
strTemp2 = "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=" & strTemp1 & ";Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine T"
With WordApp.ActiveDocument.MailMerge
.MainDocumentType = wdFormLetters
.OpenDataSource strTemp1, ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _
AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _
WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _
Format:=0, Connection:=strTemp2 _
, SQLStatement:="SELECT * FROM `Sheet1$`", SQLStatement1:="", SubType:=1打包后运行提示“字符串多于255个字符”。但是在设计环境下运行正常
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货