Import Data from another open workbook (separate instance of Excel) with partial filename

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

JP, Is the following any help? Holler back if you need more help.

Please Login or Register  to view this content.

Sauerj - thank you so much - this is working beautifully! Not sure why I couldn't get it to find the instance, but your code is doing exactly what I need.
Thank you!