Use Excel as template for calculations and import results to Access

[sterlecki]

A worksheet used as a template with many dependent formulas in various cells, requires two (cells)items of user input and has two cells of results.

Is it possible from an Access form to supply the two items of user input into 2 textboxes and use this data as the user input for the Excel worksheet? Excel would perform the calculations and the results, (two items) could be brought back to the Access form into two different textboxes?

I haven't tried anything yet, I am just investigating some generic possibilites before I respond to the user request for development. Or would it be easier to develop this entire Excel rather complex template within the form as hidden controls.

Any thoughts or a few helpful lines of code would be appreciated.

 

[PHV]

You may automate the Excel.Application object from within your access VBA code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886