Pulldown List to open Workbook.

  • Thread starter Thread starter lukus2005
  • Start date Start date
L

lukus2005

I have a supplier who updates his pricelist via several spreadsheets.
I want to create an interface so that I may access the appropriate
pricelist (workbook) by simply selecting the proper category from a
pulldown menu (list).

So basically, if I select "Piping" from the pulldown menu, it would
open "Piping.xls" either within my main workbook or by itself.

I have no macro experience so I was hoping I could do this without
using them... is this possible?
 
Opening a workbook from a dropdown box requires a macro.
You could, however, create a list of links to your workbooks (on a worksheet)
and open a workbook by simply clicking the link.

Use a hyperlink formula for each workbook you want to open...
=HYPERLINK("C:\Program Files\Microsoft Office 2003\Sludge.xls","Sludge.xls")
-or-
Use the "Hyperlink..." menu item from the Excel Insert menu.
--
Jim Cone
Portland, Oregon USA
http://tinyurl.com/ListFiles
(excel add-in to automatically list files)

..
..
..

<[email protected]>
wrote in message
I have a supplier who updates his pricelist via several spreadsheets.
I want to create an interface so that I may access the appropriate
pricelist (workbook) by simply selecting the proper category from a
pulldown menu (list).

So basically, if I select "Piping" from the pulldown menu, it would
open "Piping.xls" either within my main workbook or by itself.

I have no macro experience so I was hoping I could do this without
using them... is this possible?
 
Thanks Jim! Not the way I had envisioned but it certainly does
accomplish what I wanted.
 
Back
Top