Querying external Excel datafile from excel
Hey folks:
Looking for some help here with a project i'm doing using EXCEL ADO.Recordset objects in EXCEL VBA.
I've an external excel datafile that I want to read from within another excel file and update cells with a logic.
I'm looking for hints on how to loop through multiple rows of this external file using recordset object methods.
Thanks
|