Hi,

I would greatly appreciate some help on my problem.

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

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

How do I get


Cheer

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

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

Hi Rob,

Thanks for your reply.

Unfortunately I am still having problems because the result from the
dropdown list is still not being picked up.

I have attached the workbook and would appreciate if you could give it
a quick look as I have been racking my little brain for a few hour over
it.

Regards,

Michael


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