LuminalZero
New Member
- Joined
- Sep 5, 2012
- Messages
- 1
Hi all,
I have been tasked with creating an excel macro that will import xml files into a spreadsheet from an active directory network share. I have the code to import the files, however, if the user running the macro does not have access to the share it throws an error. Is there a way to do an on error statement that will catch the inability for the user to access the share, then provide them with a form or something that will allow them to enter their credentials, and let the program continue if the user has the correct permissions in active directory?
I have been tasked with creating an excel macro that will import xml files into a spreadsheet from an active directory network share. I have the code to import the files, however, if the user running the macro does not have access to the share it throws an error. Is there a way to do an on error statement that will catch the inability for the user to access the share, then provide them with a form or something that will allow them to enter their credentials, and let the program continue if the user has the correct permissions in active directory?
