Hello,

I would need load data from external Workbook to Combobox, but I didn't found solution.

the external workbook is on server: \\dataserver\data\login\users-file.xls
worksheet: list
data: A3->A20

I wrote

i=0
do while Workbooks(" \\dataserver\data\login\users-file.xls").Worksheets("list").Range("A3").Offset(i,0).Value <> empty
combobox1.additem Workbooks(" \\dataserver\data\login\users-file.xls").Worksheets("list").Range("A3").Offset(i,0).Value
i=i+1
loop

But it dosn't work.

Could anybody help me, please?

Martin