Hi Paul,


Thanks again for your help.


It no longer comes up with an error message for .ActiveRecord = i


However, it does now come up with a 4198 error message for SaveAs2 code


.SaveAs2 FileName:=StrFolder & StrName & ".pdf", FileFormat:=wdFormatPDF, Password:=StrPwd, AddToRecentFiles:=False


I understand that that error is associated with hyperlinks?


There is some rangetoHTML vba in the excel file, would this be causing the problem? If so how can it be resolved?


Thanks,


Canning