combobox code

[swain.s]

i can't get the following listfillrange code to work more than once
='g:\[data.xlsx]sht'!a1:c66.

after the excel file is saved and closed the listfillrange changes to
[data.xlsx]sht'!a1:c66.

what is causing this to happen

 

[p45cal]

i can't get the following listfillrange code to work more than once
='g:\[data.xlsx]sht'!a1:c66.

after the excel file is saved and closed the listfillrange changes to
[data.xlsx]sht'!a1:c66.

what is causing this to happen

I thought it'd be the other way round with the longer reference whe
the other workbook is closed. Anyway, the listboxes/comboboxes embedde
in a worksheet don't seem to want to work with closed workbooks.
assume it's the same on a user form.
The behaviour is similar to a formula referring to another workbook
only there it works regardless of whether the other is open or not