How to open file folders

dariusd77

New Member
Joined
Jan 24, 2013
Messages
26
Basically i want to be able to use a spinbox in my form to select the month the user wants to open.. so there are 12 folders 1 for each month of the year. In each folder their are five files. All five files are named the same in each folder. I would like for the user to select month.

Upon selecting month another form will pop up that will have tab buttons linked to each file.

so user scrolls to March hits enter

another form pops up with five buttons or some other command button type that list all five files.. when they select the file it opens up.

Any suggestion on how I can do this.. Please note ..yes there has to be 12 separate folders. with the 5 files inside.

Basically I need them to be able to select the file month and then the file.



Thanks for your help.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,222,564
Messages
6,166,818
Members
452,074
Latest member
Alexinho

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