Breaking News: Grepper is joining You.com. Read the official announcement!

put a filename on print to pdf in excel vba

Terrible Teira answered on May 24, 2022 Popularity 2/10 Helpfulness 1/10

answer put a filename on print to pdf in excel vba

put a filename on print to pdf in excel vba

Comment

Dim strFilename     As String
Dim rngRange        As Range

'Considering Sheet1 to be where you need to pick file name
Set rngRange = Worksheets("Sheet1").Range("K17")

'Create File name with dateStamp
strFilename = rngRange.Value & Format(Now(), "yyyymmdd hhmmss")

Sheets(Array("Dashboard Pg 1", "Dashboard Pg 2", "Dashboard Pg 3", "Dashboard Pg 4")).Select
Sheets("Dashboard Pg 1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "C:\Users\Allen\Desktop\Projects\" & strFilename & ".pdf" _
    , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
    :=False, OpenAfterPublish:=False

Sheets("Summary").Select

Popularity 2/10 Helpfulness 1/10 Language vb

Source: stackoverflow.com

Tags: excel pdf put vba

Link to this answer
Share Copy Link