forum.vdsworld.com

X-Tools

Hi,

does somebody know how to control Word through OLE ?
I want to give word the data source for a form letter.

Thanks and have a nice weekend.

Fabian

gerrit · Newbie Joined: 14 May 2004 Posts: 24

Hi...
Try thisone from Codescript.

It's for OLE2 so any Microsoft Office Products should work with it.
http://codescript.vdsworld.com/ --> OLE Document Summary

Onother way is to make it workong with the Window Send commandm, and send Keyboard shorcut's to Word.

Laughing

, Gerrit

X-Tools · Posted: Sat May 22, 2004 1:09 pm Post subject:

Hi,

thanks for your answer.
I already looked into it, but this dsu / dll is only for retrieving data from office files.
I found out that access controls word through ole for sending the data source (file location of the source).
I hoped to find dde commands for this, but I didn't found some.

Sending keystrokes is not good enough, because it has to work for different languages (german word, english word ...).

Bye, Fabian

gerrit · Newbie Joined: 14 May 2004 Posts: 24

... I'm also German...
Laughing

...but CTRL+V and Tab should work on every language.
I used the Window Send command also to automate the ebay website site to add new artikels from a Mysql Database, and its working fine for swiss english, german and dutsh languages.
Never tried with word, but I don't think it's a big diff.

What kind of ddata you want to transfair?
Sorry to do this in english, but I think it's not allowed to do it in german here... Wink

Gerrit

X-Tools · Posted: Sat May 22, 2004 2:04 pm Post subject:

oh, now I understand what you mean.

But I need to make real form letters (for ex. printing 50 personal letters) - so I make a word form letter and define my export-data-source. Now the word document will be copied to another computer, where the path to the data source is another one and my app should tell word where the source is.

Isn't there a solution for this ?

p.s. Nice to have another german on this board Wink

gerrit · Newbie Joined: 14 May 2004 Posts: 24

.... I hang a bit on Word... don't knew haow to do a series of letters...
Never used this func... Sad

But can't you use UMC Filenames to Point the Database?

I would help myself to process everything in VDS and then Copy paste it to Word..... but this insn't a proper soluten..

I have no eye deer .... Sorry...
But may somewone else have a better Idea

.

Gerrit Embarassed

Skit3000 · Posted: Sat May 22, 2004 2:51 pm Post subject: Re: OLE

X-Tools · Posted: Sat May 22, 2004 5:26 pm Post subject:

What are UMC Filenames ?

gerrit · Newbie Joined: 14 May 2004 Posts: 24

Like \\MyMashineOrIP\C\Mydocuments\MyDatabase.mdb

Don't knew for what UMC stands for...

Wink

, Gerrit

FreezingFire · **Admin Team** Joined: 23 Jun 2002 Posts: 3508

I hate to be technical but actually they're called UNC Paths Smile

DavidR · Posted: Mon May 24, 2004 9:49 am Post subject: Re: OLE

X-Tools · Posted: Mon May 24, 2004 10:02 am Post subject:

but this would only work if the file is shared and accessable from the other computer. I am searching for a solution to tell word that the source file is located on C:\Windows\Temp, .... for example.

I thought this is possible through ole or dde, but I cannot find any usefull documentation.

Bye, Fabian

arcray · Posted: Wed Jun 02, 2004 7:21 am Post subject:

Have a look at the VDSDB.DLL component from the VDSDLL available here. It will allow you to create ODBC System DSNs for your word document to access data through...