hello i have a workbook with 100 tabs. i wanted to create a macro to go through each page, create a pdf and save it in one folder. i created the below but keep getting an error on the file path.
Sub SaveEachWorksheetAsPdfFile()
'
' SaveEachWorksheetAsPdfFile Macro
Dim Worksheet As Worksheet
'Loop through all of the worksheets
'Remember to change the folder directory as well
For Each Worksheet In Worksheets
Worksheet.ExportAsFixedFormat xlTypePDF, "J:\PVT\37200\All\Account Review Committee\Meeting Materials\2021\Q4\ARC Materials\" & Worksheet.Name & ".pdf"
Next Worksheet
End Sub
Sub SaveEachWorksheetAsPdfFile()
'
' SaveEachWorksheetAsPdfFile Macro
Dim Worksheet As Worksheet
'Loop through all of the worksheets
'Remember to change the folder directory as well
For Each Worksheet In Worksheets
Worksheet.ExportAsFixedFormat xlTypePDF, "J:\PVT\37200\All\Account Review Committee\Meeting Materials\2021\Q4\ARC Materials\" & Worksheet.Name & ".pdf"
Next Worksheet
End Sub