VBA App to map a network drive

[MHultgren]

Hello all,
I am looking for a little stand alone app that I can stick on my desktop to open a dialog that will map a folder to a set drive letter. Cuurently, we have all of our projects located on a drive that is mapped to Q. Under that each of our projects are in folders that are named the same as the project number ( three digits a dash and two more digits). What I am looking for is to be able to click on an icon on the desktop that would open a dialog, type the project number into the list box and have the app map that folder to the top level of the P:\ drive. I have attached what I see the dialog looking like in case anyone is interested in playing with this.

[RobertB]

Drive mappings can only be done to shares, and I doubt the IT manager wants to create a share for every job.

[richard.binning]

Don't forget about DOS...

You can substitute the drive letter for the same results. I use the old dos subst command to emulate a network drive when disconnected from the network for this very effect.

 subst f: C:\01_THC_MIRROR\f_Drive

I had a VBS solution cooked up last year but when the hard drive crashed, I lost it.
The above code works fine in a bat file.

RLB

[MHultgren]

Thanks for the reply Robert. We have a share that is set up as the P drive already. We actually re-map each job to the P drive whenever we change from one job to another (That way our project data can be located in a sub folder under the project). But our users usually forget to do that and we end up with project data scattered across our server. I know, it's a training issue, but our Cad Manager doesn't think they need to be trained. (I think he is afraid of showing how much he doesn't know about the program). So I was looking for something that I could get everyone to use to make it easy. I have a lisp routine that will remap the P drive, but it doesn't work if you are already in a dwg in that folder. I have seen an app like that before and it was written in VBA, but I don't remember where I saw it.

[MHultgren]

I need something that cad monkeys can run without thinking about it. We have excellent Cad techs here, but they are less than decent when it comes to actually knowing how to use DOS. If it is something they can type in a box, they just might use it.

[richard.binning]

Do you need to disconnect the currently substituted drive before reassigning the drive letter to a new folder?

P.S. I have the bat routine that I run by clicking a shortcut on the desktop.

RLB

I need something that cad monkeys can run without thinking about it. We have excellent Cad techs here, but they are less than decent when it comes to actually knowing how to use DOS. If it is something they can type in a box, they just might use it.

[ntaylor]

http://www.mentalis.org/apilist/WNet...nection2.shtml

[MHultgren]

Thanks Richard and ntaylor,

I have to make this as easy as possible for the users. I just wanted a dialog that they can type in the job number and the share will be remapped to that folder. The job folder needs to be at the top level. Oh BTW, we use Novell here so that may have some impact on how it gets mapped also. I suppose I could use that BAT approach, but I would have to create one for each project ( a little more than 600, so that would not be very feasible).

[richard.binning]

You can do this using wmi, wsh, or vbs inside an hta file.

I'll try to cook up an example for you later today.



RLB