|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#3
March 7th 09, 01:17 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Add Reference to XL function (2003)
Thank you, Ken. I will do that.
-- Will "Ken Slovak - [MVP - Outlook]" wrote: You might want to post about calling an Excel UDF from outside Excel in an Excel programming group, the people there would know about that and whether an Excel COM addin can be referenced from outside. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products.htm "wpiet" wrote in message news  Is there a way to reference an Excel user-defined function in Outlook VBA? I created a Boolean function that, via a userform, accepts a username & password & authenticates them against ActiveDirectory. The function is in an Excel workbook & I can use it in VBA in any other Excel workbook by adding it via Tools/References/Browse . . . in Excel VBE. If I try to add it in Outlook VBE, it returns message, "Can't add reference to the specified file." Alternatively (preferably) is there somewhere else to create this function so that it could be used in any Office application? From research, I believe an Add-in would be ideal but I don't have Visual Studio & don't know what other options are available. -- Will 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Duplicate reference to .pst file Outlook 2003 | IraB | Outlook - General Queries | 1 | March 12th 08 10:11 PM |
| Send From function in Outlook 2003 | cruwyser | Outlook - General Queries | 1 | May 24th 06 01:52 PM |
| Outlook 2003 Quick Reference Card | Bruce | Outlook - General Queries | 2 | April 19th 06 03:41 PM |
| Outlook 2003 Import Function | pwoodbba | Outlook - Using Contacts | 1 | April 7th 06 10:22 AM |
| Signatures - Outlook 2003 & Word 2003 - Send To Function | DBH | Outlook - Using Forms | 0 | February 2nd 06 10:26 PM |
Threaded Mode