Macro to Hyperlink Command Button to open Selected Folders From a List Box

Hello,

I need some help in the following scenario.

I have Three Main Folders say X,Y,Z In "D" Drive and i want to

1. Select the main Folder using Option button....say X

2. Show the list of Subfolders in the above Selected Folder (i.e) X in a listbox.

3. Hyperlink the path of the selected subfolder from the listbox to a command button.

4. Click the command button to open the Selected subfolder

I am using the below macro to get the path list

Please Login or Register  to view this content.

I am herewith attaching the sample file.

Thanking you.

Regards,
Zaska

Hello,

Can anyone please kindly help or give me instructions?

Thank you.

Sir,

I have almost finished basic work.. Just need help with small tweaks which i am not able to understand myself. I am attaching the sample herewith.

Regards,
Zaska

Sir,

Let me make it clear if i have not explained my point clearly as shown in the Learning Sheet attached in Post #4 .

1. I have four different Folders in "D" Drive each categorized under different groups say Fruit,Food,Meat & Drink

2. I have a macro which gets the path of Each Folder ( not files) from "D" Drive... say for example : "D:\Apple"

3. I have inserted Four Option buttons to a particular Group and i have linked the option button to the list box which shows only the selected Group..For example..When i select the option Fruit then the list box displays only the Folders grouped under Fruit category.

4. When i select Apple from the list box then the command button should be hyperlinked to the apple folder in "D" Drive. This is where i got stuck.

to be more simple.

Select a folder from list box then click the command button to open the selected folder.

Thank you very much.