jumpingbean
New Member
- Joined
- Dec 12, 2005
- Messages
- 8
Hi...
I have 10 Excel files that I would like to declare in an array. This array will then be used to run in my VBA code. Currently, the code mention each file repetively. What would be the easiest way to declare the files an array?
For example thess are the files.
state1.xls
state2.xls
state3.xls
state4.xls
state5.xls
.....and so on until state10.xls
Thanks a bunch for your help and continue to enjoy life!
jumpingbean
I have 10 Excel files that I would like to declare in an array. This array will then be used to run in my VBA code. Currently, the code mention each file repetively. What would be the easiest way to declare the files an array?
For example thess are the files.
state1.xls
state2.xls
state3.xls
state4.xls
state5.xls
.....and so on until state10.xls
Thanks a bunch for your help and continue to enjoy life!
jumpingbean