Jeff Chwirut
New Member
I have a Excel workbook that I would like to execute a Access Query, populate 2 cells in a sheet (based on 2 columns in each row of query), save the workbook with name from Field #1. Loop thru each row from query and repeat process. Can this be done easily? I am fairly new to VBA. Values from Column 1 in Access data would go in R6C2, Column 2 would go in R7C2, Saved File Name would be Column 1 Value.xls. Thanks in advance for any guidance