12-27-07, 08:47 #1Registered User
- Join Date
- Nov 2007
Unanswered: automate import of many identical spreadsheets
I have several folders each containing the same identical set of excel files, where every folder stands for a specific lab.
I have another folder that contains one excel file that should import data from the above folders and place it sequentially one below another.
I can basically import one spreadsheet at a time from the menu's Import Data tool, but that will take me a decade, and I'm not so sure what would happen if I decided to change the folder structure.
So, is there a way to automate the procedure?
12-30-07, 19:19 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
Do what i do records you steps
play it a couple of times the view the code (change it see what happen)
with in a month or 2 you be written the codehope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON