VBA Check if Folder is Shared

[alfalf]

Hello.

Is there a way (besides reading folder attributes), to read if folder is shared?

I want to warn user, when saving report to desired location on disk, that folder is shared and "not safe" (or do nothing if it´s not shared).

Thanks for any suggestions.

 

[PHV]

If not on a win9x box the folder is probably shared via the default X$ where X is the drive letter.
To see what I mean execute the following command in a console window:
NET SHARE

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244