I am trying to determine if I can link fields on an Access form with related fields on an Excel worksheet, have Excel automatically do some calculations and then have the results linked back to my form.
I have been doing some research on linking Access and Excel but I am still not sure now automatic this process can be.
Here is more detail about what I want to do (Access and Excel files attached,[attachment=87295:Bmi.zip][attachment=87296:BMICalculator.zip]). I want to add data to the frmBMI except for the BMI and Percentile fields. I want the data to automatically link to row 5 in the measurements worksheet in Excel. Excel would them calculate BMI and Percentile and then link the results back to my Access form. I could then save the data, clear the fields and add data for a new student and repeat the process.
How automatic can this process be?
What the code to at least get me started?