I have an Excel macro that processes a spreadsheet. There is a column in the spreadsheet that contains names and a column that has a count of new office visits.
Question#1:
With a Loop, I can put the name into a variable and process all the names but how do I pass the variable into into Access to be used in a query that brings back the record count for the specific name.
Question#2:
Once the above has brought back a record count of the name I'm looking for from the Excel spreadsheet, how do I pass that count back into Excel to be put into the new office visits column for that person?
I open for any suggestions...
Question#1:
With a Loop, I can put the name into a variable and process all the names but how do I pass the variable into into Access to be used in a query that brings back the record count for the specific name.
Question#2:
Once the above has brought back a record count of the name I'm looking for from the Excel spreadsheet, how do I pass that count back into Excel to be put into the new office visits column for that person?
I open for any suggestions...
