The attached file demonstrates what you describe. I created a directory
C:\FactSheets containing ten Workbooks FactSheet 1 - FactSheet 10 as test
data. OpenFile contains a comboBox that allows you to open one or more of
the FactSheets. The code for the comboBox is as follows:
Private Sub ComboBox1_Change()
Application.DisplayAlerts = False
Name = Cells(18, 1).Value
Workbooks.Open Filename:="C:\FactSheets\" & Name & ".xls"
Windows(Name & ".xls").Activate
Sheets("General").Select
End Sub
Column 1 of OpenFile is used to hod the data for the comboBox. You probably
will want to hide it.
If you have any questions let me know.
Tom
On Sat, Dec 6, 2008 at 6:22 PM, Chitz <[EMAIL PROTECTED]> wrote:
>
> Hello Excel experts & wanna bez!!
>
> I need to create a automated tool where:
>
> 1. I have some 10 files with fact-sheet like information
> 2. In each file, there are 3 sheets viz General Info, Market &
> Competitors
>
> I am looking for functionality:
>
> Where a drop-down list is there on one sheet and when there a option
> is selected...that selected file will automatically open up? I can
> create a list of names with hyper link but I want to see whether it is
> possible to create automated version of time!
>
> I need a code that looks up value in drop-down list and opens matching
> file...!
>
> Hope I am clear enough.
>
> Could you please help!
>
> Thanks in advance.
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/excel-macros?hl=en
Visit & Join Our Orkut Community at
http://www.orkut.com/Community.aspx?cmm=22913620
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com
To see the Daily Excel Tips, Go to:
http://exceldailytip.blogspot.com
-~----------~----~----~----~------~----~------~--~---
OpenFile.xls
Description: MS-Excel spreadsheet
