Link to home
Create AccountLog in
Avatar of Bryce Bassett
Bryce BassettFlag for United States of America

asked on

Can VBA open a file using an IP Address?

In my Word VBA toolbars, I use the concept of a "Content Library," where the users sets a location on their local machine or network file share, where all of the resource files such as templates and graphics, for the toolbar are stored.  Once the content library is set, the file path is stored in the user registry where it can be loaded back in and used in future Word sessions without having to be re-set.  A typical content library location might be "G:\My Department\Tools\Content Library"

One of my users for some reason is unable to connect using a drive letter designation, so they asked if they can use an IP Address.  I don't know enough about networking to understand the equivalency between an IP Address and a drive letter network file share.  I suppose if we could determine that "G:\My Department" is equivalent to 999.44.333.11, he could set his content library to something like "\\999.44.333.11\Tools\Content Library."  Would that work?

Any pointers would be appreciated.  Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Dr. Klahn
Dr. Klahn

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
It sounds like you're reinventing the Workgroup Templates feature that's already in Office. This feature allows you to set a network share that is a central repository for Word, Excel and PowerPoint templates. You can set a Workgroup Templates location using an IP address. Here's my article with more information on this feature: Shared Workgroup Templates - Best Practices
Avatar of Bryce Bassett

ASKER

Dr. Klahn, that confirms what I was thinking.  An IP address and a file path are apples and oranges.  

John, thanks for the link to your article.  I've used Workgroup Templates location in past solutions.  But in this case my toolbar is not a template per se, but rather a Word "add-in" that is loaded automatically each time Word launches.  That's why it needs to live in the STARTUP folder.  Microsoft refers to this as a "global template" but that's really a misnomer.

Thanks, both, for chiming in.
Thanks again