You can copy paste the following procedure in the worksheet. In the VBA
editor (VBA project) double click the relevant sheet and paste the module
below.
'------------------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")).Rows.Count = 1 Then 'assuming that
your file-name drop down list is in cell A1
Dim fname As String
fname = Range("A1")
Workbooks.Open "C:\path\to\file\" & fname 'change as necessary
End If
End Sub
'------------------------------------
Akhilesh Kumar Karna
On Sun, Dec 7, 2008 at 8:22 AM, 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
-~----------~----~----~----~------~----~------~--~---
