Linking to Excel for Calcualtions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to switch a decision model from Excel to Access. The process
has gone smoothly until the final step. Instead of trying to get Access to do
the complicated calculations when Excel already has the formulas etc set up
within it I want to export the data entered in Access to the table in Excel
and then retrive the final answer and put it back in Access. I have linked
the Access form to the table in Excel.

So lets say Combo127, Combo128, and Combo129 has answered Yes, No, Yes in
them. I want to export these answers to Excel cells A32,A33,A34 and then take
the final answer in G32,G33,G34 and have that final answer appear in
Text123,Text124,Text125 back in the Access form.

My problem is that I have no idea how to do this, whether I have to write
code in VBA and if so I have no clue where to start on said code. Any help is
appreciated, Thanks so much!
 
I would transfer my Excel calculations to an Access Query. Most Excel
functions have an equivalent in Access. In a query, you have but to enter
the formula once to be applied to each record. So whatever you have in B32,
C32, D32, E32, and F32 can be compacted into one formula in a query.
 
Back
Top