Posts by josiahjaster

I am trying to save a large number of worksheets as html files, and I would like the titles to be different than the file names. Is there a way to save the html's with titles that are different than the file names?

For N = 0 To KPageNames.Count - 1
KOutput = KBase & "\" & KPageNames(N) & ".pdf"
Worksheets(KPageNames(N)).ExportAsFixedFormat Type:=xlTypePDF, Filename:=KOutput, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
Next N

This code segment prints the selected sheets (specified in the KPageNames list) to separate pdfs. When I upload these pdfs to the web, and open them from the web, the title appears as "loadFile.asp". I need a way to specify what the title is for each pdf - and I need the title to be different from the filename.

Is there a solution to this?