For Loop STOPS at Random Iteration!

[wjoc1]

Hi guys,

I am kinda stumped on this one...

The Background: We have a problem with Excel spreadsheets corrupting at the moment and I have been doing to basic testing to see if I can emulate this corruption. I wanted a simple spreadsheet that would open up spreadsheets on the server and save changes. I want it to do this 1000's of times to see if I could simulate workbooks corrupting. This is working however...

The Problem: The spreadsheet attached simply prompts a user to select a folder (in my case this folder will contain the test suite of spreadsheets). The program then simply cycles through this directory and opens each spreadsheet in turn, writes data to a cell and then closes it. It loops through this folder performing these actions n number of times as indicated by the user on the front sheet with the input box "Iterations". However sometimes it will stop after 35 loops of the folder, sometimes 70 sometimes 60. Why is my code stopping before it completes the number of loops specified by the user!?

If anbyone can offer any advice it would be gratefully appreciated!

Liam