This code saves my excel sheet as a PDF and then saves this named as Range "H7"
How can I change this please to save as "D19" & "-" & "H7"
Sheet1.Range("A4:J56").ExportAsFixedFormat xlTypePDF, Filename:= _
"C:\Invoices\" & Sheet1.Range("H17").Value, Openafterpublish:=True
I'm having trouble getting a macro i found here on this site to work, i have tried to do some modifications, but VB is certainly not my strong side...
This is the macro:
Sub Make_PDF()' Create and save .pdf
Dim pdfName As String, FolderName As String, SubFolderName As String, FullName...