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

The code that you have omitted is kind of crucial to see where the
error is!

How you arrive at <value from dropdown is what determines your code's
success.

Private Sub ComboBox1_Change()

Workbooks.Open _
Filename:="S:\AHCA Report 04-05\Michael\Prior year information\6\" _
& combobox1.value & ".xls"

End Sub

What were you using for <value from dropdown?

quinellus wrote:

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

--
quinellus
------------------------------------------------------------------------
quinellus's Profile: http://www.excelforum.com/member.php...o&userid=28198
View this thread: http://www.excelforum.com/showthread...hreadid=477738

--

Dave Peterson

Thanks a lot for your help! combobox1.value was what I needed.


--
quinellus
------------------------------------------------------------------------
quinellus's Profile: http://www.excelforum.com/member.php...o&userid=28198
View this thread: http://www.excelforum.com/showthread...hreadid=477738