Avatar of Bryce Bassett
Bryce Bassett
Flag 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!
VBANetworkingMicrosoft Word

Avatar of undefined
Last Comment
Bryce Bassett

8/22/2022 - Mon
Dr. Klahn

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
John Korchok

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
Bryce Bassett

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.
Bryce Bassett

Thanks again
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes