I am using Access 97 for a costing system and would like to be able to open an Excel sheet at the click of a button, do some visible calculations in Excel and transfer the results data (several cells) back to Access before closing (and possibly saving) the new instance of Excel. I can get Excel open through CreateObject but how do I copy the results back? It seems so simple! I have looked through the MSDN but this situation doesn't seem to be covered.
Any and all suggestions will be greatly appreciated.
Thanks!
Any and all suggestions will be greatly appreciated.
Thanks!