is it possible save file as pdf based on date of PC and specific text without any range ?

[KalilMe]

hello
I'm asking about save my file as pdf based on date of PC and specific text without depending on ranges
for instance the date today is 03/04/2021 and the text INVENTORY OF CARS DATE
then should save the file name is INVENTORY OF CARS DATE 03/04/2021
note : my range in the sheet from A2: H is dynamically sometimes increases I can't specify where is finished in col H
thanks for any suggestion

 

[6StringJazzer]

"INVENTORY OF CARS DATE 03/04/2021" is an illegal file name. "/" is not allowed.

You don't save a file as a PDF, you save worksheets. The example below saves the active worksheet. It is possible to select more than one worksheet for export; it works the same way as if you want to print more than one worksheet, but it sounds like you only want to export one worksheet.

If the number of rows varies, this will print whatever UsedRange is for the sheet.

   ActiveSheet.ExportAsFixedFormat _
      Type:=xlTypePDF, _
      Filename:="INVENTORY OF CARS DATE " & Format(Date, "dd-mm-yyyy"), _
      Quality:=xlQualityStandard, _
      IncludeDocProperties:=True, _
      IgnorePrintAreas:=False, _
      OpenAfterPublish:=False

 

[KalilMe]

Hi
but where is file after saved I don't find anything where run the code