Atravis
11-12-2010, 08:55 AM
Hi,
I have built a spreadsheet that imports some data from other workbooks in various locations. If users of the sheet do not have access to these folders the code breaks. I was wondering if there is anyway to check via vba whether a user has access to a folder (and possibly the type of access ie. Read only, read/write) so i could present more informative message boxes instead of having the code bug. Does anyone know of a way to do this?
I have built a spreadsheet that imports some data from other workbooks in various locations. If users of the sheet do not have access to these folders the code breaks. I was wondering if there is anyway to check via vba whether a user has access to a folder (and possibly the type of access ie. Read only, read/write) so i could present more informative message boxes instead of having the code bug. Does anyone know of a way to do this?