Macro to Open Folder

**pjw23** · 06-10-2011, 04:57 PM

I'm trying to create a macro that opens a folder based on a cell Value...

Example: I have a drop down list with three choices. a,b,c.

Under that I have a Button that I want to program a macro to open a different folder depending on which choice is made.

I assume something like that is possible, but I'm to new to VBA to know how to go about doing it. Any ideas would are greatly apprecitiated. Thanks in advance.

**MarvinP** · 06-10-2011, 05:06 PM

Hi pjw23.

We all learned to write code by turning on the "Record Macro" feature and doing something simple. They you turn it off and look at the code the Macro wrote. This is your first step in learning to code.

**pjw23** · 06-10-2011, 05:22 PM

Marvin I appreciate you stating the obvious, however, the whole problem is that I don't know how to incorporate the macro based on a drop down selection. It's pretty easy to record a macro to open a file, however, I want to open a FOLDER in explorer....Also, I want to open a specific folder based on a cells value....If you can tell me how to record that, I'm all ears...

**shg** · 06-10-2011, 06:56 PM

Why open it in Explorer? What are you going to do after it's open?

**MarvinP** · 06-10-2011, 07:45 PM

Hi shg, Thanks for jumping in.

I've just spent the last hour working through the VBA Object Browser (I hate that thing) looking for a way to set the default path before I call

Application.FindFile

which is my favorite for helping users pick files to open. I thought this would solve this OPs problem.

I've failed to find how FindFile sets where it has last been. Do you have a good answer for this in looking for setting this OPs default path? If I could find the Object I could set the default path to his dropdown and then FindFile so he could click on the correct file. I thought that was his question.

Now that I reread his answer and your post, I realize he does want Explorer.

Why not just set up a Hyperlink or do a Shell command?