I am trying finalize a process that ftps files to a unix server. This process sporadically crashes during testing.
Below is an outline of what the process does.
Call ExportCSV
Create a .CSV file for export and save it to the C drive
Copy and paste values and formats from 4 seperate but contiguous ranges (ie using pastespecial)
Save .CSV
Close.CSV
End Sub
Call CreateBAT
Print text to batch file
Close batch file
End Sub
Call CreateTXT
Create a Notepad File for output
Print server credentials, instructions, etc to notepad file
Close Notepad file
End Sub
Call SendFile
Open batchfile and FTP
Wait 3 seconds
End Sub
Call KillFiles (currently commented out to observe files)
delete all files in directory
End Sub
The macro does not always crash. But it seems that when if it does crash that it has only pasted partial data to the .CSV file for export. Could this crash be fixed by inputting a DoEvents in between the CreateCSV module and the Create Batch module?
It seems a few users experience a majority of the crash instances. Maybe they have too much open on their desktop?
Bookmarks