Forum Discussion

mydataismeaningless's avatar
mydataismeaningless
Copper Contributor
Nov 21, 2021
Solved

Finding a way to generate "report" exports (PDF) down a list of ID's

So I've provided dummy data to help explain my case. My real data has 200+ rows of employee salary info. There are two sheets: "Report" and "Data" The report values are populated by VLOOKUP based o...
BI & Data Analysis
excel
Formulas and Functions
Macros and VBA
Office Scripts
HansVogelaar's avatar
HansVogelaar
MVP
Nov 22, 2021

mydataismeaningless

Change

    wshReport.ExportAsFixedFormat Type:=xlTypePDF, Filename:=strPath & lngID & "_" & ".pdf"

to

        Dim strFullName As String
        strFullName = wshReport.Range("B4").Value
        wshReport.ExportAsFixedFormat Type:=xlTypePDF, _
            Filename:=strPath & lngID & "_" & strFullName & ".pdf"
mydataismeaningless's avatar
mydataismeaningless
Copper Contributor
Nov 22, 2021
Thank you so much! I couldn't figure this it out for the life of me.

Resources