VBA to allow a folder to be a shared folder

[Shane]

Hi All,

is there a way I can instruct Excel (VBA) to go to a folder and change that
folder say "C:\Datafiles" to be a shared folder" ???

Many Thanks
S

[Robin Hammond]

Shane,

Don't think so. And there shouldn't be. There probably is a way to do it
through the API but before you look there consider this:

I know I would be very very annoyed if somebody started messing with my file
permissions.

e.g. If you could do this easily, then why not share my root folder on the
web and then do a quick post from my machine to a web server somewhere?

How about saving whatever you need to in the Application Data area or to a
network drive?

Robin Hammond
www.enhanceddatasystems.com

"Shane" <Syd_male@hotmail.com> wrote in message
news:Qu5nf.452$Wc3.9@news.cpqcorp.net...
> Hi All,
>
> is there a way I can instruct Excel (VBA) to go to a folder and change
> that
> folder say "C:\Datafiles" to be a shared folder" ???
>
> Many Thanks
> S
>
>