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