ExportAsFixedFormat Bug

[Joepa]

Hello,

I have a problem with the ExportAsFixedFormat function, once I want to export a certain cell length to a PDF I get a PDF of 20 pages with minimal content. This is the code I am using:

ActiveSheet.Range("B1:F47").ExportAsFixedFormat Type:=xlTypePDF, Filename:=FolderPath & "/" & pdfname & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=True

Does anyone know what this problem is and how I fix it?

Translated with DeepL.com (free version)

 

[rpaulson]

you may have the slash backwords.

try
Filename:=FolderPath & "\" & pdfname & ".pdf"

 

[Joepa]

you may have the slash backwords.

try
Filename:=FolderPath & "\" & pdfname & ".pdf"

Just tried it, but it still doesn't work. On another computer with Excel it works fine, but not on my current one. Here is another example:

Excel:

https://imgur.com/s5VEubS

PDF:

https://imgur.com/yQUH3uz

Could it be something I need to adjust in my excel because it does work on another computer?