I am working on a macro whereby the user enters a search term which is used to query an Access Database. My question is how do I return those records to Excel in separate rows?
For example, a database contains home address information. If the user searches for a zip code, the records that are selected would go into row 1, 2, 3, etc. for as many records as are returned in the query.
Below is some example code - the part I am missing is clearly marked.
I appreciate any help!
Please Login or Register to view this content.