another question for Tom

[Guest]

Tom - thanks again for the help with combo boxes. In hope I am not making
too much of a pain in the a** out of myself, but can you tell me if there is
way to have the combo box scan through a folder to pull out files? Briefly,
I keep experiments organized in folders. Each experiment has a unique name,
and I do the vast majority of my number crunching in Excel. Basically, what
I am trying to do is setup a master sheet that has my work organized by
topic. I currently have the topic hyperlinked out to the word document that
details the experiment, but would like to have a combo box in the same row
that would enable me to pick through the pertinent files and open the one(s)
I want to look at. I can of course make a reference sheet that contains file
names organized by experiment, but I am fairly certain that there is probably
a more elegant way to do this. In the meantime, I am going to press the
powers that be here for a good VBA reference text. Any sugestions?

Wazooli

 

[Bob Phillips]

Do I understand if I think that you already have a list of topics, all
hyperlinking to the documents you want, on one worksheet. If so, you could
load those topics into your combobox, and when one is selected, use the
index to get the topic list item, and follow the hyperlink.

Make sense?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Since you have a worksheet with hyperlinks, you might want to look at using
the Autofilter under Data=>Filter=>Autofilter or set up sub groups with
grouping and outlining also under the data menu. If you are not familiar
with grouping and outlining, it creates a gray border area on the left that
allows you to hide and unhide rows in support of a hierarchy you set up.

You can Look at John Walkenbach's site for a listing of his books. He has
books on Excel in general, formulas specifically, charts specifically, VBA
and so forth

http://www.j-walk.com/ss/excel look on the left for links to pages on his
books.