Forum Discussion

sf49ers19238597's avatar
sf49ers19238597
Iron Contributor
Jun 11, 2025

I need help create a pdf with a button

Private Sub CREATE_GARY_TEAMS_PDF_Click() Dim FilePath As String ' Specify the output file path FilePath = ThisWorkbook.Path & "\GARY NFL TEAMS SCHEDULE.pdf" ' Select the sheets you want to export as...
excel
Macros and VBA
Kidd_Ip's avatar
Kidd_Ip
MVP
Jun 12, 2025

First thing, to use the below to include "COWBOYS FOR FRIENDS":

Dim SheetArray As Variant
SheetArray = Array("STEELERS FOR FRIENDS", "CHARGERS FOR FRIENDS", "RAIDERS FOR FRIENDS", _
                   "COWBOYS FOR FRIENDS", "COWBOYS FOR FRIENDS", "COWBOYS FOR FRIENDS", _
                   "COWBOYS FOR FRIENDS", "COWBOYS FOR FRIENDS", "EAGLES FOR FRIENDS", _
                   "BEARS FOR FRIENDS", "49ERS FOR FRIENDS", "49ERS FOR FRIENDS", _
                   "CARDINALS FOR FRIENDS", "RAMS FOR FRIENDS")

 

 

 

Resources