Problems using excel function in VB

[Guest_imported]

I really, really need help with this...

I'm trying to run the excel financial functions Price and Accrint in a visual basic program.

The normal Application.WorkSheet.Price won't work, obviously the functions are not members of the WorkSheet module...

Application.Financial.Price won't work either.

If someone could tell me how to run the functions it would be very much appreciated.

Thanks!

 

[SkipVought]

Hi Jo,

The Price function is part of the Analysis ToolPak Add-in. Has you added this add-in? Skip,
metzgsk@voughtaircraft.com