I have added the macro and this works great. Thanks for your help on this one, this has been a huge help. Looks like as long as the excel and word file are in the same directory all works perfectly.