| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| which financial function should I use? | Excel Worksheet Functions | |||
| financial function | Excel Worksheet Functions | |||
| financial function / annual rate of return | Excel Worksheet Functions | |||
| financial function ..please | Excel Worksheet Functions | |||
| help with VBA.Financial.rate error | Excel Worksheet Functions | |||
Linear Mode
