I find that attempting to use file Read Range on an empty workbook is faulting. Is this to be expected? Seems rather dumb if so.
I’ve found that I need first do a Read Cell on the first cell in the sheet. If the result is not null or empty I know I have data and can then do Read Range.
Like I said, dumb. Unless there’s some logic that is above me.