Loop Macro Crashes excel 2010

I have created a loop macro that opens a series of text files, does some clean up (removing rows and columns)
than saves the updated text file to a new location with the same name. Sometimes the macro runs through
~5 of the 14 files other times it fails on the 1 and 2nd file. Excel brings up a pop up saying "Excel has stopped
responding and needs to restart" I don't get any VB errors just the excel crash. Is my loop trying to open
multiple files at once vs in sequence? any help would be appriciated.

Please Login or Register  to view this content.

You could try some error trapping - you have a lot of superfluous code however that is not the cause of your problem. At the beginning of your code place this

Please Login or Register  to view this content.

and at the end place this

Please Login or Register  to view this content.

Report back what error you get. At the very least it should stop excel crashing.

Hope this helps.
Anthony
“Confidence never comes from having all the answers; it comes from being open to all the questions.”
PS: Remember to mark your questions as Solved once you are satisfied and rate the answer(s) questions.”

Thanks that helped. It gave me an error that the clipboard could not be cleared. searching on that error it seems to be an issue with Win7/office 2010 and Skype add-In in IE. I disabled the add-in in IE and now the code runs fine. Thanks for the help.