How to find worksheet

Have an Excel workbook trying to use a worksheet in the workbook for mail
merge. Know its my code . will not locate (MailE.xls) as data source. Here is
code line. Will some one hit me in the face so I can see what I am missing.
Excel folder is Parade also Parade is file in folder Have tried
"C:\parade\parade\MailE.xls" ThankMailE is merge doc.
Thanks

ChangeFileOpenDirectory "C:\Parade"
Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _


ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",

Russ
Fri Aug 03 13:12:58 CDT 2007

You have to enter the Windows path to that folder. What do you use outside
of Word in Windows Explorer to get to that file?


> Have an Excel workbook trying to use a worksheet in the workbook for mail
> merge. Know its my code . will not locate (MailE.xls) as data source. Here is
> code line. Will some one hit me in the face so I can see what I am missing.
> Excel folder is Parade also Parade is file in folder Have tried
> "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
> Thanks
>
> ChangeFileOpenDirectory "C:\Parade"
> Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
>
>
> ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
>

--
Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Russ
Fri Aug 03 13:23:51 CDT 2007

One trick that I like to use to get a path, is to open a Dos window and
separately through Windows Explorer go to a file, then drag and drop that
file from Explorer on top of the Dos window. The full path to that file will
appear in the Dos window and you can copy it to the clipboard for pasting.
This works great for network paths, too.
To open a Dos window, go to Start button in Windows, click on Run, enter
cmd.

> Have an Excel workbook trying to use a worksheet in the workbook for mail
> merge. Know its my code . will not locate (MailE.xls) as data source. Here is
> code line. Will some one hit me in the face so I can see what I am missing.
> Excel folder is Parade also Parade is file in folder Have tried
> "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
> Thanks
>
> ChangeFileOpenDirectory "C:\Parade"
> Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
>
>
> ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
>

--
Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Curt
Fri Aug 03 14:00:01 CDT 2007

Thanks for the input we all learn different tricks
Thanks again

"Russ" wrote:

> One trick that I like to use to get a path, is to open a Dos window and
> separately through Windows Explorer go to a file, then drag and drop that
> file from Explorer on top of the Dos window. The full path to that file will
> appear in the Dos window and you can copy it to the clipboard for pasting.
> This works great for network paths, too.
> To open a Dos window, go to Start button in Windows, click on Run, enter
> cmd.
>
> > Have an Excel workbook trying to use a worksheet in the workbook for mail
> > merge. Know its my code . will not locate (MailE.xls) as data source. Here is
> > code line. Will some one hit me in the face so I can see what I am missing.
> > Excel folder is Parade also Parade is file in folder Have tried
> > "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
> > Thanks
> >
> > ChangeFileOpenDirectory "C:\Parade"
> > Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
> >
> >
> > ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
> >
>
> --
> Russ
>
> drsmN0SPAMikleAThotmailD0Tcom.INVALID
>
>

Curt
Fri Aug 03 14:42:01 CDT 2007

path shows up as you stated all I need is to get into file for a worksheet it
is a Excel worksheet in Parade.xls

"Russ" wrote:

> One trick that I like to use to get a path, is to open a Dos window and
> separately through Windows Explorer go to a file, then drag and drop that
> file from Explorer on top of the Dos window. The full path to that file will
> appear in the Dos window and you can copy it to the clipboard for pasting.
> This works great for network paths, too.
> To open a Dos window, go to Start button in Windows, click on Run, enter
> cmd.
>
> > Have an Excel workbook trying to use a worksheet in the workbook for mail
> > merge. Know its my code . will not locate (MailE.xls) as data source. Here is
> > code line. Will some one hit me in the face so I can see what I am missing.
> > Excel folder is Parade also Parade is file in folder Have tried
> > "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
> > Thanks
> >
> > ChangeFileOpenDirectory "C:\Parade"
> > Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
> >
> >
> > ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
> >
>
> --
> Russ
>
> drsmN0SPAMikleAThotmailD0Tcom.INVALID
>
>

Russ
Sat Aug 04 01:32:46 CDT 2007

I typed in opendatasource into Word VBA Help and the opendatasource method
help had this snippet of help for the connection parameter:

****Quote
Connection Optional Variant. A range within which the query specified by
SQLStatement is to be performed. How you specify the range depends on how
data is retrieved. For example:
? When retrieving data through ODBC, you specify a connection string.
? When retrieving data from Microsoft Excel using dynamic data exchange
(DDE) (Windows only), you specify a named range.
? When retrieving data from Microsoft Access (Windows only), you specify
the word "Table" or "Query" followed by the name of a table or query.
****UnQuote

So create a named range for the worksheet data in Excel and pass that as the
Connection parameter. And maybe a SQLStatement query on that range is not
actually needed, so try it first without using a SQLStatement.

> path shows up as you stated all I need is to get into file for a worksheet it
> is a Excel worksheet in Parade.xls
>
> "Russ" wrote:
>
>> One trick that I like to use to get a path, is to open a Dos window and
>> separately through Windows Explorer go to a file, then drag and drop that
>> file from Explorer on top of the Dos window. The full path to that file will
>> appear in the Dos window and you can copy it to the clipboard for pasting.
>> This works great for network paths, too.
>> To open a Dos window, go to Start button in Windows, click on Run, enter
>> cmd.
>>
>>> Have an Excel workbook trying to use a worksheet in the workbook for mail
>>> merge. Know its my code . will not locate (MailE.xls) as data source. Here
>>> is
>>> code line. Will some one hit me in the face so I can see what I am missing.
>>> Excel folder is Parade also Parade is file in folder Have tried
>>> "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
>>> Thanks
>>>
>>> ChangeFileOpenDirectory "C:\Parade"
>>> Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
>>>
>>>
>>> ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
>>>
>>
>> --
>> Russ
>>
>> drsmN0SPAMikleAThotmailD0Tcom.INVALID
>>
>>

--
Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

Curt
Sat Aug 04 12:14:00 CDT 2007

For one learning you are a great asset your explanation makes sense.
Thanks

"Russ" wrote:

> I typed in opendatasource into Word VBA Help and the opendatasource method
> help had this snippet of help for the connection parameter:
>
> ****Quote
> Connection Optional Variant. A range within which the query specified by
> SQLStatement is to be performed. How you specify the range depends on how
> data is retrieved. For example:
> â?¬ When retrieving data through ODBC, you specify a connection string.
> â?¬ When retrieving data from Microsoft Excel using dynamic data exchange
> (DDE) (Windows only), you specify a named range.
> â?¬ When retrieving data from Microsoft Access (Windows only), you specify
> the word "Table" or "Query" followed by the name of a table or query.
> ****UnQuote
>
> So create a named range for the worksheet data in Excel and pass that as the
> Connection parameter. And maybe a SQLStatement query on that range is not
> actually needed, so try it first without using a SQLStatement.
>
> > path shows up as you stated all I need is to get into file for a worksheet it
> > is a Excel worksheet in Parade.xls
> >
> > "Russ" wrote:
> >
> >> One trick that I like to use to get a path, is to open a Dos window and
> >> separately through Windows Explorer go to a file, then drag and drop that
> >> file from Explorer on top of the Dos window. The full path to that file will
> >> appear in the Dos window and you can copy it to the clipboard for pasting.
> >> This works great for network paths, too.
> >> To open a Dos window, go to Start button in Windows, click on Run, enter
> >> cmd.
> >>
> >>> Have an Excel workbook trying to use a worksheet in the workbook for mail
> >>> merge. Know its my code . will not locate (MailE.xls) as data source. Here
> >>> is
> >>> code line. Will some one hit me in the face so I can see what I am missing.
> >>> Excel folder is Parade also Parade is file in folder Have tried
> >>> "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
> >>> Thanks
> >>>
> >>> ChangeFileOpenDirectory "C:\Parade"
> >>> Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
> >>>
> >>>
> >>> ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
> >>>
> >>
> >> --
> >> Russ
> >>
> >> drsmN0SPAMikleAThotmailD0Tcom.INVALID
> >>
> >>
>
> --
> Russ
>
> drsmN0SPAMikleAThotmailD0Tcom.INVALID
>
>

Curt
Mon Aug 06 08:20:02 CDT 2007

Gaining on operation noe I am looking as to where I create another OLE app.
Waiting to complets. Any way thanks your expl sure helped

"Russ" wrote:

> I typed in opendatasource into Word VBA Help and the opendatasource method
> help had this snippet of help for the connection parameter:
>
> ****Quote
> Connection Optional Variant. A range within which the query specified by
> SQLStatement is to be performed. How you specify the range depends on how
> data is retrieved. For example:
> â?¬ When retrieving data through ODBC, you specify a connection string.
> â?¬ When retrieving data from Microsoft Excel using dynamic data exchange
> (DDE) (Windows only), you specify a named range.
> â?¬ When retrieving data from Microsoft Access (Windows only), you specify
> the word "Table" or "Query" followed by the name of a table or query.
> ****UnQuote
>
> So create a named range for the worksheet data in Excel and pass that as the
> Connection parameter. And maybe a SQLStatement query on that range is not
> actually needed, so try it first without using a SQLStatement.
>
> > path shows up as you stated all I need is to get into file for a worksheet it
> > is a Excel worksheet in Parade.xls
> >
> > "Russ" wrote:
> >
> >> One trick that I like to use to get a path, is to open a Dos window and
> >> separately through Windows Explorer go to a file, then drag and drop that
> >> file from Explorer on top of the Dos window. The full path to that file will
> >> appear in the Dos window and you can copy it to the clipboard for pasting.
> >> This works great for network paths, too.
> >> To open a Dos window, go to Start button in Windows, click on Run, enter
> >> cmd.
> >>
> >>> Have an Excel workbook trying to use a worksheet in the workbook for mail
> >>> merge. Know its my code . will not locate (MailE.xls) as data source. Here
> >>> is
> >>> code line. Will some one hit me in the face so I can see what I am missing.
> >>> Excel folder is Parade also Parade is file in folder Have tried
> >>> "C:\parade\parade\MailE.xls" ThankMailE is merge doc.
> >>> Thanks
> >>>
> >>> ChangeFileOpenDirectory "C:\Parade"
> >>> Documents.Open FileName:="ThankMailE.doc", ConfirmConversions:=False, _
> >>>
> >>>
> >>> ActiveDocument.MailMerge.OpenDataSource Name:="C:\Parade.xls\MailE.xls",
> >>>
> >>
> >> --
> >> Russ
> >>
> >> drsmN0SPAMikleAThotmailD0Tcom.INVALID
> >>
> >>
>
> --
> Russ
>
> drsmN0SPAMikleAThotmailD0Tcom.INVALID
>
>