Hello all...
I have an importing problem and hoping one of you can help.

I currently have a macro that initiates a function to export data from another application. That "export" launches a new instance of Excel, and names the file "grid1_xxxyyyzzz.xls" where xxxyyyzzz is not predicable in value or length. The file name does consistenly start with "Grid1_" and it is always an xls.

I need to grab the contents of the first worksheet in that new workbook, which is consistently named "Worksheet"

Due to the security of the other application, this new workbook is not saved in a download or temp repository that I can get to, which means, I believe, I have to get the data once the new workbook opens.

The challenge here, for me, is that I can't find the filename because it's in that second instance, so I can't get to the data.

Any help is appreciated!!!

Thanks
JP