asked on

Instantiating VBA financial functions through VBScript

I need to access PMT and RATE functions found within the VBA library through an ASP page.
I don't want to really wrap this function within a COM object and reference that way. I was hoping to be able to access these functions through VBScript via a valid PROGID.
The server on which this will reside will not have MS Office installed on it.
The backend is SQL Server 7 with no OLAP services installed [unable to use a stored procedure to compute rate or pmt]

Does anyone have any ideas?
Thanks

mastallama

you could write them into a DLL file and call it in the ASP page.

~ MastaLlama ~

asbailey

ASKER

I was wondering if I could directly access these functions via VBScript without using a DLL
EG:
<%

Dim objA
Dim dblPMT
Set objA = server.createobject("?")
dblPMT = objA.PMT(....)

%>
THe problem is working out the PROGID [i.e. "?"]

ASKER CERTIFIED SOLUTION

mastallama

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

asbailey

ASKER

It looks like VBA objects don't support IDispatch interface that allows Automation....rats man
Thanks for your help ~ MastaLlama ~

mastallama

no problem

~ MastaLlama ~

mastallama

by the way...

Why the grade of "C"?

you asked: "I was hoping to be able to access these functions through VBScript via a valid PROGID. "

i told you it's not possible unless you create a DLL, you said: "I was wondering if I could directly access these functions via VBScript without using a DLL"

again i said, it's not possible.

i find no logic in a "C" grade...

~ MastaLlama ~