Calling a user defined excel function from Access VBA

[millzy7]

Hi,

I am trying to call an user defined excel function from MS Access. I know the WorksheetFunction call exists but what similar function can i use to call a function that isnt a built-in Excel function?

Thanks

Millzy

 

[PHV]

Have a look at the Excel.Application.Run method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886