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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

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

NickHK

"Eugene via OfficeKB.com" <u32520@uwe wrote in message
news:71f53abe3343e@uwe...
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

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


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

NickHK

Hi!

[quoted text clipped - 9 lines]
Thanks,
Eugene

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

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

"ekim via OfficeKB.com" <u32520@uwe wrote in message
news:7204b9f311450@uwe...
Thanks, but I'm looking for a VBA solution, not a VB.Net.


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

NickHK

Hi!

[quoted text clipped - 9 lines]
Thanks,
Eugene

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

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?



NickHK wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1

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

"ekim via OfficeKB.com" <u32520@uwe wrote in message
news:728bbde82a290@uwe...
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?



NickHK wrote:
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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200705/1