Within Access, I am trying to use code to save a currently open and active Excel workbook to a calculated location and filename and then extract values from various cells. I already have code that can open an Excel file that is at a known location and filename but haven't found code that can refer to an Excel workbook that is already open. (The workbook is opened from an incoming email message and then a form within an Access database is completed to log the incoming sheet and then I want code to determine where to save and what to name that open workbook.) Thanks for any and all suggestions.
(I have thought that I could create an Excel macro to save the file to a temp folder with a temporary name and then go to the Access form but want to try and eliminate as many user steps as possible in this process.)