Generate form for directories?

robfo0 · Mar 22nd, 2002, 09:51 PM

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

Al Chara · Mar 22nd, 2002, 09:57 PM

I'm heading home soon, but research userform, chdir, folders, SubFolders, FileName, open. This should get you started in the right path.

Tom Schreiner · Mar 23rd, 2002, 03:08 AM

Two questions.
Are you using Office 2000?
Is everybody who uses this workbook running the same version as you?

robfo0 · Mar 23rd, 2002, 12:45 PM

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.

Mar 22nd, 2002, 09:57 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	I'm heading home soon, but research userform, chdir, folders, SubFolders, FileName, open. This should get you started in the right path. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 09:51 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 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

Mar 23rd, 2002, 03:08 AM	#3
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Two questions. Are you using Office 2000? Is everybody who uses this workbook running the same version as you?

Mar 23rd, 2002, 12:45 PM	#4
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	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.