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
...
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