Hi,
I have an excel spreadsheet which I periodically save using VBA. I have another spreadsheet that uses a connection link to read cell data from the spreadsheet that I save. Every now and again I get an error on the save spreadsheet that says that the save could not happen because another user is accessing the file.
Does anyone know if there is a way in VBA to detect if the save can not be performed due to the data read and retry a save at a set time later? I want to stop this error message.
thanks
I have an excel spreadsheet which I periodically save using VBA. I have another spreadsheet that uses a connection link to read cell data from the spreadsheet that I save. Every now and again I get an error on the save spreadsheet that says that the save could not happen because another user is accessing the file.
Does anyone know if there is a way in VBA to detect if the save can not be performed due to the data read and retry a save at a set time later? I want to stop this error message.
thanks