Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Livelink documents and VBScript

Status
Not open for further replies.

foolsgarden

Programmer
Jan 16, 2007
2
ZA
Hi,
I'm new to livelink, dont know it at all but i need to write a vbscript that will take the livelink link (the fetch command to the relevant document), copies the content of that document to an open word document. What I need to know is how to manipulate Livelink to be able to copy the contents?

I have a list of direct links to Livelink (fetch) word documents. We want to automatically create one word document which includes all these livelink links documents contents. Instead of copy and paste each link, open the livelink document, copy all contents and paste into new word document, we want to automate this process. Can anyone please help me in how to do this.

Thank you
 
Once again clarifying the requirement.As an example is it correct to assume that you have three documents docA,docB and docC which are in livelink,and its links that you know of.You would want to make a mergedDocument D which is actually the contents of docA+docB+docC.

Here are some things to get you started since you say you are a starter.

When you click a fetch document,what is heppening behind the scenes is livelink will check your login,permissions and locate the document in its doc repository and send it down to your computer.If you have word in your computer it auto recognizes the content now sitting in your Temporary Internet Files/Content IE5/random folder windows creates and lo and behold the document is open in word.

What I am getting at is livelink just served the document,it did not open or process the content of the document.

So what I would do is first find out if VB script allows you to manipulate word documents,if so getting the content from livelink is a breeze.You maybe in luck with the newer office versions because it says it is stored in true xml fashion and obviouysly vbscript can parse xml.

You have programming methods such as lapi,non programming methods such as xmlexport to get your content from livelink and that should be the least of your worries.

Good Luck

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
 
you should be able to use the Windows Scripting Host to interact with Word and then get it to open each document and then copy and paste it into a new document, covers a simple implemenation using Excel rather than Word, but the concepts should get you going. also gives some samples for Excel using the copy and paste example.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005
 
Yes, I want to merge the documents in livelink to one document, manipulating word with VBScript is a ease. Thank you, you all have touched some topics i never thought about. Will have a look at it all. Thanx again
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top