- Joined
- Jan 22, 2008
- Messages
- 4
- Reaction score
- 0
Hi
I have written a procedure in Outlook which takes some info from e-mails, transfers the info to an Excel workbook then runs a macro in excel that inserts some formulae to calculate some stuff.
I have the reference to Excel in Outlooks References.
All fine EXCEPT when any of the formuale contain functions contained within the Analysis Toolpack Addin for excel. Then I just get Name? returned. The Excel macro works fine when it is run from Excel but not when it is run from Outlook. So I am guessing I need to add a reference in Outlook which will enable this.
Can anyone help?
Thanks
I have written a procedure in Outlook which takes some info from e-mails, transfers the info to an Excel workbook then runs a macro in excel that inserts some formulae to calculate some stuff.
I have the reference to Excel in Outlooks References.
All fine EXCEPT when any of the formuale contain functions contained within the Analysis Toolpack Addin for excel. Then I just get Name? returned. The Excel macro works fine when it is run from Excel but not when it is run from Outlook. So I am guessing I need to add a reference in Outlook which will enable this.
Can anyone help?
Thanks