Hi,

Could someone please tell me why the data from the combo box is not being added into the path of the file name in the following code?

Private Sub ComboBox1_Change()

Workbooks.Open Filename:="S:\AHCA Report 04-05\Michael\Prior year information\6\" & <value from dropdown> & ".xls"


End Sub


Regards,

Michael