I should clarify, just turning off alerts in the options menu may not be an option. This app will be used by people who need these switches on. In addition to the standard confirmation dialogs that pop up, I also run into warnings about disk space ("You will not be able to undo this...
Most of my VBA experience is in using Excel. I'm working on a project in Access 97 that will import a few hundred large text files and perform a set of action queries after each import. With each iteration, I get 4 or 5 dialog boxes ("You are about to append x lines", "You are about to update...
I have a string array that contains the path and file name of each workbook in the directory.
So basically.. nothing.
Is there a way to determine if a workbook object contains a macro without opening it?
I'm looking to put together a VBA procedure that will loop through all xls files in a directory and determine if any macros exist. Is this possible?
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.