ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ListFillRange linked to named range in a closed remote file (https://www.excelbanter.com/excel-programming/327465-listfillrange-linked-named-range-closed-remote-file.html)

Chuck Hyre

ListFillRange linked to named range in a closed remote file
 
I'm trying to use the ListFillRange to populate listbox controls in a
workbook for remote distribution. For maintenance reasons I'd like to keep
the list sources in a central location rather than farming them out with each
copy of the file. The values available in most listboxes changes based on
choices made earlier, so the user display is highly fluid.

Although I can use ListFillRange dynamically when the file is open, for the
life of me, I can't figure out the correct syntax to refer to the source file
(using UNC structure) that will work.

If anyone can help I would greatly appreciate it. Thanks!


All times are GMT +1. The time now is 07:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com