[VBA] Save Range and Chart to 1 PDF

Author Summary

gulbronson is in VBA

Post Body

I am trying to create a pdf that has a range on the first page and charts on the following pages. Right now my code looks like this:

Private Sub Create_PDF_Click()

Dim Fname As String

Fname = Application.GetSaveAsFilename(InitialFileName:=suggest_name)

If Fname = "False" Then
    Exit Sub
End If

Sheets("Sheet1").Range("A2:K30").ExportAsFixedFormat Type:=xlTypePDF, Filename:=Fname, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=True

End Sub

I can't find a way to add the charts though.

Author

Account Strength

100%

Account Age

13 years

Verified Email

Yes

Verified Flair

Total Karma

155,151

Link Karma

29,387

Comment Karma

124,641

Profile updated: 1 month ago

Posts updated: 10 months ago

gulbronson

Subreddit

r/excel

Post Details

Location

VBA

We try to extract some basic information from the post title. This is not always successful or accurate, please use your best judgement and compare these values to the post title and body for confirmation.

Posted: 9 years ago
Reddit URL: View post on reddit.com
External URL: reddit.com/r/excel/comme...