Hi xld,

by the way, it is kinda weird, that the speicif file that gets updated is put in the last order , i mean "set wrkboo4 = workbooks.open( path of file 1)
wrkbook4.activate" i actually run the other 3 files first....

and no matter how i change the order of runing them...still that file gets udpated..

so i guess it has something to do with that "application.run ecowinudpated"

since in each workbook, there is such a line "application.run ecowinudpated". all same...the difference is that all the codes is written in sub workbook_open in the file that gets updated. In other 3 files, this line is written in stardand modules which would be called from workbook_open.
that is
sub workbook_open()
call updating
end sub

in the moduel

sub updating()
application.run "ecowinupdated"
end sub


does this matter?