View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams[_4_] Tim Williams[_4_] is offline
external usenet poster
 
Posts: 114
Default Shared folder changed path - sometimes S://SharedFolder sometimes T://SharedFolder

On Jan 29, 9:13*am, GS wrote:
<FYI
What I've learned is that VB[A] can't work with 'mapped' drives on a
network because those are for use by the system only. What the system
does is to create a 'virtual namespace' as a 'pointer' to the actual
location on the network. In this case it's been easier to prompt the
user via the folder picker dialog when the stored path throws an error.


VBA *can* work fine with mapped drives, as long as the drive letter is
consistent.

If each user has a different drive letter mapped, then the UNC path
should be used instead.

Tim




--
Garry

Free usenet access athttp://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc- Hide quoted text -

- Show quoted text -