I have an application that runs every minute. It updates Excel data and saves it as a csv file. The file is then sent via an ftp transfer. The problem is that the macro stops and waits for the operator when the file is in use by one program. You get the retry, cancel option message box. I would like to solve this problem when the file is being accessed. I would like to have it ignore the problem, wait perhaps 15 seconds, and then retry. All this automatically. Can anyone help me with this?
Ad Choices