VBA code to export excel as PDF does not export it with images

[YingFa]

Hello,

I am using this code Wks.ExportAsFixedFormat xlTypePDF, FileSpec & "\" & File & ".pdf", but if I place images on the excel, it does not export the on the PDF file. Can I have your help on this? I need the pdf to be exported with the images placed on the excel file.

Thank you.

 

[DanteAmor]

Right-click the picture, then click the Size and Properties option. This is going to open a new window.
Select Properties tab.
Check Print Object option.

 

[YingFa]

Hi, thank you for your reply on this. The print object is checked but it still does not work. The excel file is exported as a PDF without images. Is there any code to print as PDF instead of saving as pdf?

 

[DanteAmor]

Try with all parameters:

Wks.ExportAsFixedFormat xlTypePDF, FileSpec & "\" & File & ".pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False

 

[YingFa]

Try with all parameters:

Wks.ExportAsFixedFormat xlTypePDF, FileSpec & "\" & File & ".pdf", _
        Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False

Hi, sorry for the late reply. I think I overlooked your response. I have tried the code but even though I have images on the excel from, they are not exported when the excel is converted to PDF. Any idea why?