populate a listbox with values from a range in a closed workbook on a server

D

dovrox

How would I populate a listbox with details from a range from a close
workbook on a server
 
B

Bob Phillips

Either open it and get the data, or use ADO and get the recordset into an
array.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top