Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,355
Default 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.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default 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
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VLOOKUP with restricted access rights DaveO[_2_] Excel Worksheet Functions 2 August 6th 07 08:20 PM
Excel user access rights gti_jobert[_87_] Excel Programming 0 April 18th 06 03:26 PM
Limit Files via VBA not folder rights or permissions Curt Excel Programming 5 December 29th 05 03:39 PM
Read folder access rights Eric van Uden[_2_] Excel Programming 4 October 28th 05 05:27 PM
Access Rights & Reports John F.M. Excel Worksheet Functions 1 May 31st 05 09:54 PM


All times are GMT +1. The time now is 10:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"