Invoking Excel Financial Functions Without Instantiating Excel?

[PeteCresswell]

Right now, I'm instantiating Excel and going at them via the
Excel.Application object.

But it's kicking the brains out of a certain screen's load time -
where it has to call the same computation with different data 10-20
times to populate a list.

I've got it to where the Excel instance persists and does not have to
be re-created; but it's still too slow.

Question: Is there a .DLL or something withing the MS Office install
that I can go to directly and get the same functions?

 

[mark]

Right now, I'm instantiating Excel and going at them via the
Excel.Application object.

But it's kicking the brains out of a certain screen's load time -
where it has to call the same computation with different data 10-20
times to populate a list.

I've got it to where the Excel instance persists and does not have to
be re-created; but it's still too slow.

Question: Is there a .DLL or something withing the MS Office install
that I can go to directly and get the same functions?

 

[Clif McIrvin]

Pete, have you asked this question over in m.p.excel? I've had pretty
good success getting answers over there.

Being a some-time programmer who doesn't know any better, I was going to
suggest creating a class module with the functions of interest as
methods of that class, instantiating that class at start-up from some
always-open form and referring to those methods as needed.

Then i re-read your post and noticed that you have persisted your Excel
instance ... so I've no idea if using a class module would help or not.

Could it be that the performance hit you're seeing isn't coming from
invoking the Excel Application object, but rather is due to the way that
the Excel analysis function itself processes the data? Perhaps a custom,
specific purpose function library instead of the more generalized Excel
Analysis Tools is in order?

Just thinking out loud ....

 

[Clif McIrvin]

Question: Is there a .DLL or something withing the MS Office install
that I can go to directly and get the same functions?

Curious ... did you discover another way to invoke Excel / analysis pak
functions?