Hi,

Could someone please tell me why the data from the combo box is no
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 yea
information\6\" & <value from dropdown & ".xls"


End Sub


Regards,

Michae

--
quinellu
-----------------------------------------------------------------------
quinellus's Profile: http://www.excelforum.com/member.php...fo&userid=2819
View this thread: http://www.excelforum.com/showthread.php?threadid=47773