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?

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?

 

[Fluff]

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

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.