Workbooks.Open Filename:= "S:\AHCA Report 04-05\" & <value from dropdown & ".xls"

--
Regards;
Rob
------------------------------------------------------------------------
"quinellus" wrote in message
...

Hi,

I would greatly appreciate some help on my problem.

I have set up a combo box in a spreadsheet where the user selects a
country from the dropdown list. I then want to insert the country
selected into the pathname of the file to be opened . . .

Workbooks.Open Filename:= _
"S:\AHCA Report 04-05\country.xls"

How do I get


Cheers


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