So I tried the code you provided and made some slight alterations with turning the screen updating to false and creating the IsFileLocked function. The code starts running and then stops responding. When I recover the word file I can see the code has worked perfectly for the first row of information in the excel file but thats where it appears to stop. I cant seem to determine why its not continuing on to each subsequent row in the excel file. Any thoughts?