Initializing Add-Ins as Excel is Opening
Posted by Rob G on March 30, 2001 9:05 AM
I am having a problem getting rid of an error message. My macro starts using the Auto_Open procedure, which has in it some lines that determine if the 'Analysis Toolpack' and 'Analysis Toolpack - VBA' Add-Ins are installed and if not, then to install them. I use the worksheetfunction command in order to use the Isodd() and Mround() functions in my code. What is happening is that VBA compiles all the code before hitting the Auto_Open procedure, and if the Add-Ins are not installed then an error message appears, before installing my Add-Ins. Is there any way of getting around this? How does Excel initilalize the code? Can I install the Add-ins during the initialization portion of opening the workbook?
Any comments will be greatly appreciated!!