This post (https://www.excelforum.com/excel-pro...ml#post5899205 ) started out somewhere in general excel, ended up in VBA, and I'm now asking if anyone who knows Power Query might want to comment. In short, the OP wants to extract information from a closed Excel file without opening the file in the process. It's always the same information from the same location in the spreadsheet, but a different file each day. Can anyone with experience accessing closed files in Power Query (or any other Excel tool) comment?

I made a comment about database design. I think there might be room for someone experienced in database design to comment about the value in building good databases, too (though I'm not sure the OP is ready to accept a tutorial on better database design).