File name from two cell values

[VbaHell]

Hello All

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

 

[Joe4]

I think it usually looks cleaner to build the file name separately in a variable, then reference that variable, i.e.

Dim myFileName as String
myFileName = [COLOR=#333333]"C:\Invoices" & [/COLOR][COLOR=#333333]Sheet1.Range("D19") & "-" & [/COLOR][COLOR=#333333]Sheet1.Range("H7")[/COLOR]
Sheet1.Range("A4:J56").ExportAsFixedFormat xlTypePDF, Filename:= _
[FONT=Verdana]    myFileName[/FONT], Openafterpublish:=True

 

[VbaHell]

Works a treat Joe4

Thank you very much

 

[Joe4]

You are welcome.

By the way, there should be a backslash after "Invoices" in my variable.
Sometimes, the board does weird things and drops backslashes and greater than or less than signs.