I am trying to get access to folders on a server that normally the user will
not have permission to access but do want to allow access to this XL
workbook irrespective of the user. That is I want to be able to read/write
files in a folder programatically from an XL workbook without giving the
user read/write permission on that folder.
Is there a way to do this?

Thanks
Fred

Fred,
May be you could create a share and then remove it when finished
http://vbnet.mvps.org/code/network/netshareadd.htm

NickHK

"Fred" <leavemealone@home> wrote in message
news:(E-Mail Removed)...
> I am trying to get access to folders on a server that normally the user
will
> not have permission to access but do want to allow access to this XL
> workbook irrespective of the user. That is I want to be able to read/write
> files in a folder programatically from an XL workbook without giving the
> user read/write permission on that folder.
> Is there a way to do this?
>
> Thanks
> Fred
>
>