i'm trying to copy every 10 minutes some data from another excel file (file 1) that is continuously open at another computer (and also is saved every 5 minutes) into my own file (file 2)
now in file 2 i have a macro that opens that other file as read only and copies some data and closes it without saving..only i keep getting the message that the other file is locked for editing by another user (the guy who has file 1 open)..
how can i avoid this message? or has it something to do with the autosaving of file 1?
now in file 2 i have a macro that opens that other file as read only and copies some data and closes it without saving..only i keep getting the message that the other file is locked for editing by another user (the guy who has file 1 open)..
how can i avoid this message? or has it something to do with the autosaving of file 1?
