Change to VB code to ignore error when saving file

[scarlett3]

I have an Excel file A on my server that reads live data. Via a macro, a different Excel file B is opened every 20 minutes, specific cell ranges are copied over from the original file A and then Excel file B is closed.

This stops working when, presumably, someone else is querying Excel file B (via asp script) as I receive a 'can't save Excel file B because the file is read-only' error message. The more serious issue is that the code in Excel file A is paused because of the 'read-only' error so I don't have the live data stored in Excel file A after the error message.

I'm using a simple [ActiveWorkbook.Save ActiveWindow.Close] code to save and close Excel file B.

Is there a way to change the code such that the 'read-only' error is ignored and the code in Excel file A continues to run regardless of any save/close error in Excel file B?

Thanks

 

[sykes]

Try this:

Sub ign_err()
'First part of your code here...
On Error GoTo err_handler
    ActiveWorkbook.Save 'etc etc
    'etc etc
GoTo noerror
err_handler: MsgBox "There was an error saving Excel file B!", 48

noerror:
On Error GoTo 0
'Rest of your code here...
End Sub

 

[scarlett3]

Thanks for your help, sykes.

However, it sticks on the message box.

These files are not monitored in real-time on my server, so this needs to run automatically without user intervention.

 

[sykes]

Oh, I thought you wanted a message...
Being lazy (for a quick response) just ditch the messagebox, then - thus:

Sub ign_err()
'First part of your code here...
On Error GoTo err_handler
    ActiveWorkbook.Save 'etc etc
    'etc etc
err_handler: On Error GoTo 0
'Rest of your code here...
End Sub

 

[scarlett3]

Thanks!