Macro Error - Write error

Microsoft Office excel 2007 home & stude...
August 19, 2010 at 06:25:31
Specs: Windows 7
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?

See More: Macro Error - Write error

Report •

August 19, 2010 at 15:55:43
This should be posted here for more help:

Report •
Related Solutions

Ask Question