so a couple updates - using some ‘creativity’ I was able to build cards to copy the workbook, then find it and the sheets within it.
Using those find values I tried to ‘stuff’ them into the read rows card. Error…
cards without the test data
the ‘read all rows’ card
and the error
I sorta know why it wont work. While it does appear that you can force the filename you cant ‘stuff’ the worksheet.
Too bad - it would seem that you should be able to reference a spreadsheet and/or worksheet if you have the proper data.
Still looking for ideas…come on you smart guys…somebody has had to figure this out before me.