asingh
09-18-2006, 03:00 AM
Hi,
I have the following questions about add ins. If some one could guide me to a comprehensive article..or answer them here..it would be great...!
1. When an add in is being 'coded'. Where should the code be placed. In a separate module in the workbook, or in a Workbook Event. [If yes, which event]....?
2. Once the add in has been saved as .XLA type...how is it added so, each time I launch Excel it is available.....?
3. How do I fire the add in....? i.e get it to execute....?
4. If I save a file, with an add in embedded all ready in my excel, and I mail it to someone, will they need to install the add in. Or will they receive the file with the add in pre-installed..? Or will their sheet throw up an error...?
thanks a lot.....
regards,
asingh
I have the following questions about add ins. If some one could guide me to a comprehensive article..or answer them here..it would be great...!
1. When an add in is being 'coded'. Where should the code be placed. In a separate module in the workbook, or in a Workbook Event. [If yes, which event]....?
2. Once the add in has been saved as .XLA type...how is it added so, each time I launch Excel it is available.....?
3. How do I fire the add in....? i.e get it to execute....?
4. If I save a file, with an add in embedded all ready in my excel, and I mail it to someone, will they need to install the add in. Or will they receive the file with the add in pre-installed..? Or will their sheet throw up an error...?
thanks a lot.....
regards,
asingh