Reference large spreadsheets without opening them

Hi forum members...

I have a daily spreadsheet which on average is 400,000 KB in size.

Is it possible, to have a txt file or equivalent with between 100-1000 entries on, that the primary workbook is able to reference ID's on the txt file without opening - in the background, and export the full lines of the referenced ID's onto a fresh xlsx - being small enough to then review quickly.

If yes, would anyone be able to point me in the right direction?

Thank you.

Use e.g.:

Code:

---

Sub OpenLatestFile()
    c00 = "\\\Output\Chris\*shopone"
    with Getobject(Split(CreateObject("wscript.shell").exec("cmd /c dir """ & c00 & """ /b/s/a-d/o-d").stdout.readall, vbCrLf)(0))
        sn=.sheets(1).usedrange
        .close 0
    end with
End Sub

---