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

[michaelchen]

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.


--
Regards,
Tom Ogilvy

"michaelchen" <michaelchen@discussions.microsoft.com> wrote in message
news:7DDDDFE5-1B88-4AF6-8907-358AABE00F0E@microsoft.com...
> 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.
>

[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



"michaelchen" <michaelchen@discussions.microsoft.com> wrote in
message
news:7DDDDFE5-1B88-4AF6-8907-358AABE00F0E@microsoft.com...
> 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.
>

[michaelchen]

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" <michaelchen@discussions.microsoft.com> wrote in message
> news:7DDDDFE5-1B88-4AF6-8907-358AABE00F0E@microsoft.com...
> > 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.
> >
>
>
>

[michaelchen]

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" <michaelchen@discussions.microsoft.com> wrote in message
> news:7DDDDFE5-1B88-4AF6-8907-358AABE00F0E@microsoft.com...
> > 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.
> >
>
>
>