Use execl financial function(Ex:PMT/RATE Function) with ASP

[Guest]

Hi, I'm trying to write Mircosoft ASP code to call excel financial
functions, like PMT/RATE functions, but most examples online are talking
about creating and getting objects.

Anyone has any idea how to do it or any reference?
Any input is appreciated.

 

[Tom Ogilvy]

Are you asking how to do it with objects (automation) or how you can call a
function in Excel without having excel loaded.

 

[Chip Pearson]

I don't know ASP, but if you have a reference to the Excel
Application, you can call built-in Excel functions via the
WorksheetFunction class.

application.WorksheetFunction.Pmt(...)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



message
news:[email protected]...

 

[Guest]

Hi Ogilvy:
I think i need to call a function in excel without having excel loaded.
Any Idea/Advice greatly appreciated.

Best Regards.
Michael

 

[Guest]

Hi Ogilvy:
I think i need to call a function in Excel without having excel loaded
with ASP via VBScript / Activex COM / or some component .

Any idea / advice greatly appreciated.

Best Regards.
Michael