VBA code to range into dictionary using ADODB.Connection from closed file and creating a column for lookup

[balajiksubash]

Hi All,

This is my first post in the forum. Looking forward for help from the members.

Need a VBA code that will fetch data from a closed file using ADOBD.Connection into a dictionary and in the dictionary create an additional column for vlookup. Finally paste the data into the activeworkbook. Hope this can be done in VBA.