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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is it possible to open LiveLink Explorer from Word VBA?

Status
Not open for further replies.

JerseyMike4

Technical User
Nov 1, 2011
2
US
I hate to sound like a noob here, but is there a way to open LiveLink Explorer using Word VBA? I know the code to open a standard folder is:

Shell "explorer " & "C:\", vbNormalFocus

When I try adding the LiveLink address in place of "C:\" I just get an error message. The path for LiveLink is odd because it doesn't have a drive letter, so I'm guessing there must be more to the address that I'm trying, which is:

"Livelink\PROD\Enterprise Workspace"

Any help would be appreciated. (I'd also like to know if there's anything else with LiveLink I can do in VBA, but first things first.)
 
I am not sure I understand the qn. Livelink Explorer(Connect) uses a call to a configured livelink server and shows Folders in livelink.Livelink is not a 100 % equivalent to a file system.However if you have webdav product installed in livelink then it can be made to behave like a windows file system.For working with VBA in the older time one used to use the lapi libraries or the XDK(now obsolete).My gut feel is that if you want to treat it as a file folder perhaps the use of VBA or while in explorer create a shortcut to a folder in livelink and put it on the desktop.See if you can launch the shortcut from VBA and base that for other folders if they work at all.

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer,Livelink ECM Champion 2008,Livelink ECM Champion 2010
 
Hi appnair. Thank you for your reply.

I really don't know if we have webdav product installed, but I would assume we do since we can open LiveLink through Windows Explorer and treat it like a Windows file system (i.e. we can drag-and-drop files).

We can (and I do it often) create shortcuts to specific folders. Without testing it, I would agree that I could probably use VBA to simply launch the shortcuts. The problem is that I share my macros with others and if another user doesn't have the same shortcut in the same directory that I do, the macro I write won't work for them.

I was hoping there might be a way to launch LiveLink in a standard Explorer window, but I take it it's not that easy.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top