Thank you Tom for your help, if I could borrow your brain for one mor
thing.

I've been able to retrieve the values from multiple files usin
something like this:


Code
-------------------

Dim wb As Workbook
Application.ScreenUpdating = False
Set wb = Workbooks.Open("filename.xls", True, True)

Get the values, close the file, free up memory etc.


-------------------


Is there away to do the same thing using this ExecuteExcel4Macr
funtion? I grabbed the following off the net and it retrieves th
value of a specific cell without opening the file. Is it possible tha
instead of asking for a specific cell, ask for the value of the dro
down object? And if so, which way is best?


Code
-------------------

Dim arg As String
arg = "'" & path & "[" & file & "]" & sheet & "'!" & Range(ref).Range("A1").Address(, , xlR1C1)

GetValue = ExecuteExcel4Macro(arg)

-------------------


Thanks

--
entonn
-----------------------------------------------------------------------
entonne's Profile: http://www.excelforum.com/member.php...fo&userid=1503
View this thread: http://www.excelforum.com/showthread.php?threadid=26656