Unanswered: Joining two worksheets in separate workbooks
I have two different excel files, and I have two ADODB connections to these files in my code.
I need to do a left join on a worksheet from one file with a worksheet from the other file.
How can I do it in one single SQL statement (which would normally be possible if both worksheets were from the same file = 1 connection)?
I understand I cannot supply both both connections to the objRS.Open line...
Is it even possible?