Hi everyone,
I have some code that will go into every excel file (all formatted the same) and extract data i need to the current worksheet. But i would like to be able to do more, and make it easier.
Would it be possible to generate a form which looked for all the directories in a given directory, then ask the user to check which directories they wanted to search in. then i could loop my code for all the checked directories?
My directories are as follows:
into each year, "YEAR 2001", "YEAR 2002" etc
Then each year has every month "01-01","02-01" etc...
Then there are even more directories inside of these. but i just want the check boxes to generate for each month so we can do a report say for the last 3 months or whatever we choose.
thanks for any help
I have some code that will go into every excel file (all formatted the same) and extract data i need to the current worksheet. But i would like to be able to do more, and make it easier.
Would it be possible to generate a form which looked for all the directories in a given directory, then ask the user to check which directories they wanted to search in. then i could loop my code for all the checked directories?
My directories are as follows:
into each year, "YEAR 2001", "YEAR 2002" etc
Then each year has every month "01-01","02-01" etc...
Then there are even more directories inside of these. but i just want the check boxes to generate for each month so we can do a report say for the last 3 months or whatever we choose.
thanks for any help