Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP with restricted access rights | Excel Worksheet Functions | |||
Excel user access rights | Excel Programming | |||
Limit Files via VBA not folder rights or permissions | Excel Programming | |||
Read folder access rights | Excel Programming | |||
Access Rights & Reports | Excel Worksheet Functions |