Hi all,

I'm looking for some assistance with a project I'm working on, it's pretty complex and I have some of the steps already working, but I'm in need of someone to throw me a line with this because it's currently defeating me.

I know how to do all these steps manually, but the time frame i have i dont think i could possibly complete it in time, so basically what I'm looking for is any of the steps to be automated, so i would be able to complete it before the required.

Step one would be to resolve the Share to the physical location, currently on the list it mentions \\servername\share, what i need is \\servername\$driveletter\physical location\share area. As it stands i'm currently using computer management to get the share path, which is a very long process in it's self. Is there a way to use vba to resolve a share path to the physical location path?

Step two, pulling the groups from the path. Currently i have a script that does this outside of excel, so this step is not particularly holding me up. I also have a way to pull the members of these groups to show me the global groups where the users are based, so that kinda ticks off step 3.

I also have a vba script to pull the users from the groups.

So essentially, if at all possible, does anyone have a method of resolving share names to physical paths? or does anyone have a method of pulling security groups from file paths using vba?


Regards,

Vio