I'm using the template wizard with data tracking, I need to create a macro that will loop to open all of the .xls files within a folder, save each, and create a new record or update an existing record...
I have a checklist that will be completed by 100 +/- individuals and e-mailed back. I intend to dump them into this folder and run the macro from within a separate workbook to populate my database.
Could someone suggest a macro the would open each .xls file, save, and create/update a record? If create or update causes a problem. I could use one that just created a new record... I could clear the database before running. Any thoughts? Thanks!
I have a checklist that will be completed by 100 +/- individuals and e-mailed back. I intend to dump them into this folder and run the macro from within a separate workbook to populate my database.
Could someone suggest a macro the would open each .xls file, save, and create/update a record? If create or update causes a problem. I could use one that just created a new record... I could clear the database before running. Any thoughts? Thanks!