[AccessD] Access Application Obtaining Data fromExcel-Another User Has Excel File Opened

Brad - the only downside to the super simple file copy approach:
It may not have been recently "saved". You would be getting the copy of the
workbook the user opened early that day.

However, even with automation, to get the most recent data, you would need
the workbook to be established as "shared" so that you can then do the
"Save" for them and then making a "Save As" under a different name.