Reading a .CSV file open in another instance of Excel

My office utilizes software that enables its data to be exported as a CSV file. When the export occurs, the CSV file automatically opens in Excel (as a CSV file).

I currently have the user copy the entire sheet into a designated sheet in a workbook that then performs operations on the data.

To save the less tech savvy users a step, I would like a procedure that finds the open CSV file (in Excel) and copies the data to the separate workbook for data manipulation, however CSV files open in Excel (and not saved as Excel files) are not indexed in Workbooks().

Does anybody know of a way to finding CSV files that are being viewed in Excel, and then manipulate it (i.e. copying it).