Hi chumley, and welcome to the forum!
Basically builds the file path. So if your workbook is saved in C:\Temp, the sPDFPath variable will return:Code:'/// Change the output file name here! /// sPDFName = "Consolidated.pdf" sPDFPath = ActiveWorkbook.Path & Application.PathSeparator
Then you'll see later in the code references to:Code:C:\Temp\
Which would return:Code:sPDFPath & sPDFName
It's not showing up in the directory that your workbook is in though?Code:C:\Temp\Consolidated.pdf