Generate form for directories?

robfo0

Active Member
Joined
Feb 19, 2002
Messages
281
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
I'm heading home soon, but research userform, chdir, folders, SubFolders, FileName, open. This should get you started in the right path.
 
Upvote 0
Two questions.
Are you using Office 2000?
Is everybody who uses this workbook running the same version as you?
 
Upvote 0
Yes TS Tom, as of right now, myself and everyone else is using office2k, but in the future, that may change to office 2002, I'm not sure.
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

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