VBA to create PDFs through loop

[analyst3]

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

 

[analyst3]

could someone please tell me what i am doing wrong. thanks

 

[John_w]

Is the worksheet name a valid file name?