We help IT Professionals succeed at work.
Get Started

Can VBA open a file using an IP Address?

80 Views
Last Modified: 2020-01-11
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!
Comment
Watch Question
Principal Software Engineer
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE