PDA

View Full Version : Browse Function



faye
12-11-2005, 07:46 PM
Hi, i had an input box that will requires to state the workbook to open and retrieve the data from. But the problem is that, the user needs to enter the full path to the workbook as well as the worksheet name which is kind of a hassle. So i was thinking is it possible to produce the "browse" function which windows uses?

Thanks!

Zack Barresse
12-11-2005, 07:57 PM
Seach the site and/or the KB for the GetOpenFilename method. :)

faye
12-11-2005, 10:39 PM
okay... It's solved. It's my fault for not searching the site for answer before posting it on the forum.....

Thanks for the help! This site rocks!

faye
12-11-2005, 10:54 PM
okay... there's one more thing. The worksheet name... how am i going to allow user to select that?

Thanks

Zack Barresse
12-12-2005, 12:03 PM
There really isn't anything you can do to have the user select the sheet name without opening the workbook. What exactly are you wanting them (your user's) to do? Why do they need to select a sheet, and when?