Running Macros from my Add-in

[Neil07979]

Hello Again all,

I've created an Add-in which is going to be used by multiple users:

Part of the functionality of the Add-in is to run daily, weekly and monthly data and format in to reports. I have all the code to do this - however this is based in an Excel file that I was going to use as the control mechanism before I managed to create it Via an Add-in.

1st Question - is how would I reference the code within the spreadsheet once the workbook is open? I need to open this workbook anyway - as all the data will be stored there.

2nd Question - IS this the best way to do this - or would it be more practicle to store the code within the Add-in?

Any help is much appreciated:

Thanks, Neil

[royUK]

An addin should contain the code and generally have a menu to access the macros. See

http://www.excelforum.com/showthread...highlight=menu