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

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.

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

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


--
Regards,
Tom Ogilvy

"michaelchen" wrote in message
...
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.

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

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



"michaelchen" wrote in
message
...
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.

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

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

Best Regards.
Michael


"Tom Ogilvy" wrote:

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


--
Regards,
Tom Ogilvy

"michaelchen" wrote in message
...
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.

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

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

"Tom Ogilvy" wrote:

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


--
Regards,
Tom Ogilvy

"michaelchen" wrote in message
...
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.