test to see if you have write access to a folder

[red6000]

Hi,

I have some code that saves files to a folder on a another drive (ie
J:\savedfiles\).

Is there any code that can test to see if I have write access to that
folder?

ie:

If writeaccess to J:\savedfiles\ = true then
save file here
else
save file to own drive
end if

Thanks

 

[Russ]

You could trap for errors, there is probably a specific error code for can't
save. Type Error in VBA help.
I think vb and vba share some of the same error codes.

http://www.halfile.com/vb.html