directory window keeps opening up

[almagg]

i am linking cells between workbooks.

when i paste the directory(?) window opens up wanting me to select the correct file. like it doesn't know exactly which file i am linking.

this is what i paste.

='[2007 Department Expense Summary - 10018.xls]Summary'!D24

then the window opens up and i have to manually select the xls file that is in the brackets.

i dunno.

 

[almagg]

yeah, don't know how that got there
but it was correct in the code

that window is still popping up

 

[almagg]

it is working now - the problem was...

...

i did not pay attention to the file names.
* for two of them, there was an extra space before the hyphen
* for five of them of them, the words "Initial Submission"
followed "Summary"
* and for three of those the word was spelled "Sumbission"

ActiveCell.Value = "='N:\IT Analysis Group\2007 Plan\Cost Center Files to Link\[2007 Department Expense Summary - 10015.xls]Summary'!" & myaddress

i knew it wasn't myyy code

 

[erik.van.geit]

you're welcome

in fact when i manually do the paste, the window does not open up.

this was not true