I have posted this before and learned a lot of things. However, my basic problem still exists. I export some data to excel, excel does some calcs, then sends back results. To get back results, excel must be opened and closed after receiving data from Access. My code works fine in Access 2003 and 2007. But, in Access 2016, the excel file doesn't open and close, so results are not imported. (Excel does receive the exported data).
In order to not complicate things, I am attaching a very simplified version of my file. (My regular file exports 51 values and imports 16 results.) In newer fast computers, leaving the excel file open during the export/import provides good quick response. Other computers take 20 plus seconds to respond. Without going into detail, linking isn't a choice.
I hope someone can modify the attached simplified file to get the excel file to open-close after receiving the data in Access 2016. Works fine in 2007. Thanks much in advance.