ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Folder access rights (https://www.excelbanter.com/excel-programming/392675-folder-access-rights.html)

Sam

Folder access rights
 
I can use a custom function "PathExists" (courtesy of jwalk) to indicate that
I am mapped to a directory, but how can I test if I have access to that
folder?

Any help would be appreciated.

Barb Reinhardt

Folder access rights
 
Try something like this

=pathexists("C:")

HTH,
Barb Reinhardt

"Sam" wrote:

I can use a custom function "PathExists" (courtesy of jwalk) to indicate that
I am mapped to a directory, but how can I test if I have access to that
folder?

Any help would be appreciated.


Dave Peterson

Folder access rights
 
Maybe just trying to create a file (a text file) would be sufficient. You could
kill it if you created it.

But there are different levels of rights, too. Read Only, Read/Write,
Read/Write/Create, Read/Write/Create/Delete. You may want to test all the
things you need to use.

Sam wrote:

I can use a custom function "PathExists" (courtesy of jwalk) to indicate that
I am mapped to a directory, but how can I test if I have access to that
folder?

Any help would be appreciated.


--

Dave Peterson

Tom Ogilvy

Folder access rights
 
Think Dave gave you some good advice on how to check.

This article will give some insights into one of the alternatives:

http://support.microsoft.com/kb/115945/en-us

--
Regards,
Tom Ogilvy


"Dave Peterson" wrote:

Maybe just trying to create a file (a text file) would be sufficient. You could
kill it if you created it.

But there are different levels of rights, too. Read Only, Read/Write,
Read/Write/Create, Read/Write/Create/Delete. You may want to test all the
things you need to use.

Sam wrote:

I can use a custom function "PathExists" (courtesy of jwalk) to indicate that
I am mapped to a directory, but how can I test if I have access to that
folder?

Any help would be appreciated.


--

Dave Peterson



All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com