Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop-Down List to Choose File to Open
I would like to be able to choose a filename from a drop-down combo bo
and then open the file by clicking on a button with a macro link. The problem is when I tried recording the macro, I am only able t record one file name and I would like to be able to open up any fil selected, so that it can be pasted into a sheet in the curren workbook. Here is what I have so far: Sub Button7_Click() Range("N3").Select Selection.Copy ChDir "I:\Inv\H R" Workbooks.Open Filename:= _ "I:\Inv\H R\CH(March).xls" Cells.Select Application.CutCopyMode = False Selection.Copy Windows("Copy of K P M v4.xls").Activate Sheets("data").Select Cells.Select ActiveSheet.Paste Windows("CH(March).xls").Activate ActiveWindow.Close Sheets("PM").Select Range("K20").Select End Sub Any suggestions on how to make this work? Please be as specific a possible, because I'm new at this. Thanks -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down List w/ Values Pop Automacailly when choose entry from l | Excel Discussion (Misc queries) | |||
choose a product from a drop down list i need it to insert a price | Excel Worksheet Functions | |||
How do I choose from the drop down list in excel | Excel Discussion (Misc queries) | |||
How do I insert A drop down dialog box as a 'list to choose from'? | Excel Worksheet Functions | |||
Drop-Down List to Choose File to Open | Excel Programming |