Instantiating VBA financial functions through VBScript
Posted on 2002-07-17
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?