VBA for Exporting to PDf

I need a VBA code to save a worksheet as the current file name and export to PDF. The code below is what I got when I recorded this action. The problem is that the file path and file name will change monthly, so I need it to be for the current path & name. How do I modify this code to do that?

Sub PDFExport()
'
' PDFExport Macro
' To save AIA Line Breakout to PDF as billing summary sheets for backup file.
'

'
ChDir _
"H:\001 Monthly Billings\2023\02 FEBRUARY 2023\001 CINFAB\UC Health\002 SI Infill"
ActiveWorkbook.SaveAs Filename:= _
"H:\001 Monthly Billings\2023\02 FEBRUARY 2023\001 CINFAB\UC Health\002 SI Infill\SI INFILL FEBRUARY 2023 LABOR & MATERIAL DETAILS.xlsm" _
, FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
ActiveWindow.Close
End Sub

Thank you for the response, but I cannot try the demo you sent me because my company has the macros blocked. From your description, it does not sound like what I am looking for. The path and name will change every month, so I need the code to use the current name and path without being anchored to a specific workbook like my current code. This macro will be grouped with several others in a button, so that I can just click the button and everything will be automated. It should not require any input from the user.

Originally Posted by jolivanes

Or

Please Login or Register  to view this content.

Thank you for the quick response. This partially worked. It saved the PDF, but not the Excel file like the "Save As PDF" function does. Also, when I tried to open the PDF, it gave me an error about it being corrupted because of the way it was created.

Originally Posted by jolivanes

Don't quote whole posts. Refer to a post number and/or particular poster.
It creates nothing but not needed clutter.

I am sorry my reply bothered you. But, if that is a rule of this forum, then it should not have a button that says "Reply With Quote". It would also have been nice if your reply would have included some helpful information that actually pertained to my post so that it was not a complete waste of time for me to come here to read your reply.

I said they blocked the macros on that file. They were blocked because it was from an unknown source. We do not have an IT department, just one IT person. This is not in his wheelhouse. His job is to keep the company connected and all tech running smoothly and efficiently. Daily usage of the software programs is not part of his responsibilities, therefore he has no reason to learn complex features of the applications. Thank you for your attempt to help. Have a great day!