Scan my network for any shared folders

[Eugene via OfficeKB.com]

Hi!

Actually did not know where to post this message, as there is no separate
group for VBA.
How do I look for shared resources in my network? I've walked through the
search results and found a code that uses the scripting object technique to
access shares, but it only works locally. Did anyone tried to develop such a
solution?

Appreciate any help you may provide.

Thanks,
Eugene

 

[NickHK]

Eugene,
Maybe this:
http://vbnet.mvps.org/code/network/netshareenum.htm

NickHK

 

[ekim via OfficeKB.com]

Thanks, but I'm looking for a VBA solution, not a VB.Net.

Eugene,
Maybe this:
http://vbnet.mvps.org/code/network/netshareenum.htm

NickHK

Hi!

[quoted text clipped - 9 lines]

Thanks,
Eugene

 

[NickHK]

Eugene,
Did you read the link ?

If you had, you would have seen it is in VB, usable in VBA.
The site has been around a lot longer than VB.Net.

NickHK

Thanks, but I'm looking for a VBA solution, not a VB.Net.

Eugene,
Maybe this:
http://vbnet.mvps.org/code/network/netshareenum.htm

NickHK

Hi!

[quoted text clipped - 9 lines]

Thanks,
Eugene

 

[ekim via OfficeKB.com]

Yes, I did, and followed the instructions to create that tool, but it doesn't
return anything.
Also, I noted in the code that it is designed to list all shared resources on
my machine, not on the network. Should I always know the remote machine's
name to be able to retrieve its shared resources?

Eugene,
Did you read the link ?

If you had, you would have seen it is in VB, usable in VBA.
The site has been around a lot longer than VB.Net.

NickHK

Thanks, but I'm looking for a VBA solution, not a VB.Net.

[quoted text clipped - 9 lines]

 

[NickHK]

Randy's code is pretty solid, so I would guess the problem lies with
how/what you are doing, not his code.

And if you check the code you will see:
'demo using the local machine
bServer = "\\" & Environ$("COMPUTERNAME") & vbNullString

So you need to give it the name of the remote server instead.
Check related pages on that site to see the code to obtain a list of
computers on your network.

NickHK

Yes, I did, and followed the instructions to create that tool, but it doesn't
return anything.
Also, I noted in the code that it is designed to list all shared resources on
my machine, not on the network. Should I always know the remote machine's
name to be able to retrieve its shared resources?

Eugene,
Did you read the link ?

If you had, you would have seen it is in VB, usable in VBA.
The site has been around a lot longer than VB.Net.

NickHK

Thanks, but I'm looking for a VBA solution, not a VB.Net.

[quoted text clipped - 9 lines]

Thanks,
Eugene

 

[Eugene via OfficeKB.com]

Yes, that piece of code is the reason I decided it is for local machine.

Big thanks to you, Nick.

Randy's code is pretty solid, so I would guess the problem lies with
how/what you are doing, not his code.

And if you check the code you will see:
'demo using the local machine
bServer = "\\" & Environ$("COMPUTERNAME") & vbNullString

So you need to give it the name of the remote server instead.
Check related pages on that site to see the code to obtain a list of
computers on your network.

NickHK

Yes, I did, and followed the instructions to create that tool, but it doesn't
return anything.

[quoted text clipped - 15 lines]