Macro to open .xls files in a folder and update database

Mtaylorlc

New Member
Joined
Mar 31, 2002
Messages
42
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!
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Hi
What database?
Access?
Names of tables?
Names of fields in each table?
Data arrangment on individual worksheets?
....10 more questions...
Big question with so little info.
E-Mail TsTom@hotmail.com if you are unable to get the help you need.
I need some database practice.
Tom
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,998
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top