Can excel do a calculation in Access??

[Ezyflo]

I have complex calculations that need to be done in Excel. Is it possible to have excel do the calcs and have the results show in Access?

If so, how would I go about doing this?

i.e. I have a form where the user will be prompted for information. Depending on what they input, various calculations will be performed. I want to have a field on the form where the result will show.

If you have any ideas please let me know.

Thanks

 

[FoxProProgrammer]

I realize that this doesn't answer your question directly, but what sort of calculations are you trying to do? I'd be surprised if all the calculations available in Excel aren't available in VB. It would simplify your application if you could do everything in Access. dz
dzaccess@yahoo.com