Saving an Excel File as PDF in the same location as the Excel File

Hi,

I have some script for setting the print area and saving as PDF. However, this is saving to a personal file XLSTART. Is there code to save the PDF file in the same folder as where the Excel file is saved?

Help as always greatly appreciated.

Thanks.