combobox listfillrange network
 

How can I make a listfillrange look up a range in a LAN i.e.
\\filesrv\data\book1.xlsx {rangename}