• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Macro - check write access for selected folder

D

Dhamo

New Member
Hi,


I have a browse button in my userform. And it will return folderpath(destination folder). but I need to verify whether I have access to create the file in the selected folder. Please help.!!
 
I think something like the method described here will work:

http://www.ozgrid.com/forum/showthread.php?t=79132


Provides a Boolean function to check if a file can be written to. If it's truly just the folder you want to check, looks like the best that can be done is an error trap after you attempt to save.

http://www.mrexcel.com/forum/excel-questions/428243-check-folder-permission-visual-basic-applications.html
 
You must log in or register to reply here.
Back
Top