hello,

I have an excel program that has several custom mathematical functions
built into it via add-ins. At the present time, I have to export the
data from sql to excel and then have the macro in excel
compute certain columns and then save it as excel then send it back to
sql via DTS. This whole process is manual.

I would like to know if it possible to call or reuse this custom excel
functions from analysis services, so that I can have all computations
run on the server itself without having to DTS it out.

Worst case, is it possinble to invoke excel from transact sql using the

exec master.dbo.xp_cmdshell so that atleast part of this process can be
automated.

Thanks.

Cheers,Padhu