i got 1 computer that autosaves a excel file with VBA and 2 other computers that`s trying to get the infromation.

[Mette85]

hello.
i`m using 1 computer with a sheet that`s running autosave with vba. and the 2 other computers are getting information from that computer with "Get data" and refreshing every 5 minutes.
But the timers will come on the same time now and then.
My question to this is: Is it possible to use a VBA code to Ignore the " the file is being used by another user "?
i havent figured out how to do that.

Does someone know?

 

[Mette85]

this is what is use on 1 computer, the other one is 5 minutes... and i`m suppose to run even 2 more computers on this..
but it stoppes when the 2 computers are getting information at the same time? not when the file saves? right?