I really need some help or guidance. I need to import 42 spreadsheets into my database everyday. i use a transferspreadsheet DoCmd in VBA but i was thinking that if i used a 'looping' procedure of somekind this would be easier. All of my spreadsheest are labeled ####Aging.xls. i would need something that could rotate the first four numbers (like an array?) i have never used an array can someone help?
Thanks for the response. I think its a little more involved... The #### represent specific numbers not just 1 ,2 ,3, 4... I think an array would work because it would let me store these location numbers in one group. Does any one agree with my array theory? I am new to using arrays...
Where are you setting / getting your numbers for the spreadsheets
Depending on what you are doing with your spreadsheets it my make sense to read the numbers from a table, ok I know it sounds over the top to use a relational database for this but consoder the situation that some bright spark decides to change the number of spreadsheets to process.
If they are set via a form then adding or removing spreadhseets from the list becomes a trivial non programming matter - it could be deployed using a MDE database rather than a MDB. It also shifts the responsibilty for making the changes to the processing the users responsibility rahter than yours. Sods law always suggests that the bright spark forgets to mention to you the changes untill the project is way past critical delivery time and you are about to go on holiday
Healdem- I may change to a table and create the relationship like you suggested. Right now i just wanted this to work. We plan on adding alot of locations in the coming year so you suggestion may prove to be valuable. THANKS!