OpenDataSource

[JC]

Greetings,

First time post, first time writing VBA, enjoying it.

I have a Word template with a Macro that calls:

OpenDataSource ("C:\folder\ole.xls")

This works as we want it to except that there is a DataLink Properties
dialogie that appears, the user clicks OK and we proceed. I believe this
gets a ConnectionString, can I bypass the dialogue?

TIA
C

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?SkM=?=,

Version of Word is always necessary when asking mail merge related
questions. A lot of things changed a few years ago...

My recommendation: Record a macro when connecting to the data source in
order to see what kind of information Word requires. Adapt your VBA code
accordingly.

First time post, first time writing VBA, enjoying it.

I have a Word template with a Macro that calls:

OpenDataSource ("C:\folder\ole.xls")

This works as we want it to except that there is a DataLink Properties
dialogie that appears, the user clicks OK and we proceed. I believe this
gets a ConnectionString, can I bypass the dialogue?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail