work around for string longer then 255 error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Duane Reynolds 322310 - 06 Feb 2008 05:49 GMT

I have they following line from a recorded macro i am tweaking to run from a
different machine. when i copied the full path to the file i got string
longer then 255 error . how can i shorten this line of code to run without
this error. thanks for your help
Duane Reynolds

Reply to this Message

Duane Reynolds 322310 - 06 Feb 2008 05:51 GMT

forgot to insert code

ActiveDocument.MailMerge.OpenDataSource Name:= _
"C:\Documents and Settings\reynoldu\Desktop\AutoFillInspRpt.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=C:\Documents and
Settings\reynoldu\Desktop\AutoFillInspRpt.xls;Mode=Read;Extended
Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database="""";Jet
OLEDB:Registry Path="""";Jet OLEDB:Database Password="""";Jet OLEDB:Engin" _
, SQLStatement:="SELECT * FROM `RadGridExport$`", SQLStatement1:="",
_
SubType:=wdMergeSubTypeAccess

thanks
Duane
"Duane Reynolds 322310" <Duane_nospam_R@wpgelectric.com> wrote in message
news:...

>I have they following line from a recorded macro i am tweaking to run from
>a different machine. when i copied the full path to the file i got string
>longer then 255 error . how can i shorten this line of code to run without
>this error. thanks for your help
> Duane Reynolds

Reply to this Message