I want to use a macro to save an .xls file as an .mht file. I have:
ActiveWorkbook.SaveAs Filename:="C:\Reports\Book2.mht", FileFormat:= _
xlWebArchive, CreateBackup:=False
which works for saving, but how can I Change the resulting web Page Title using VBA? I tried recording the...