OpenDataSource

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JC - 29 Oct 2004 15:14 GMT

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

Reply to this Message

Cindy M -WordMVP- - 01 Nov 2004 20:13 GMT

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.
>
[quoted text clipped - 5 lines]
> 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 :-)

Reply to this Message