Open Filepath and then display number of sheetnames using VBA

**fodio** · 09-21-2010, 05:34 AM

Hi Experts,
I need help here. I am trying to use VBA to open and display a Filepath from another excel file and then respectively list/display a list of Sheetnames inside that file, in another cell or a drop down list. I have done my homework and I have problems trying to merge the 2 VBA scripts below.

To Open File Path and display at Cell D5
--------------------------------------------------------

Please Login or Register  to view this content.

To list down the names of the sheet.
--------------------------------------------------------

Please Login or Register  to view this content.

---------------------------------------------------------

Any kind soul can assist please.

Would really appreciate it.

**pike** · 09-22-2010, 02:29 AM

Hi fodio,
Kris http://krisexcelpostings.blogspot.com/
has done all the hard work with this example

**fodio** · 09-23-2010, 11:15 PM

Originally Posted by pike

Hi fodio,
Kris http://krisexcelpostings.blogspot.com/
has done all the hard work with this example

Hi Pike, Many thanks for your response.
This is sweet

But however, what i wanted it to do is when it list out the Worksheet name on Listbox2, i want it upon Double Clicking will list the name of the Worksheet name on Range("d5").Value

Is this possible if you can assist me with it, i tried but couldn't.

Many thanks.