Macro Help!

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I am creating a combo box in which a user will be able to
select a month, and based upon that selection I need a
macro that will open a specific file. For example, if the
user selects June, then I need the macro to open the June
report, if the user selects July, I need the macro to open
the July report, etc.
 
Jeff,

Workbook.Open Filename = myPath & "\" & Combobox1.Value & ".xls"

Just put in your file path.
 
Back
Top