ExportAsFixedFormat xlTypePDF
the function ExportAsFixedFormat xlTypePDF does not print images, charts or graphs.
For example
Sub PrintReport()
Dim sPath As String
sPath = "/path/to/myreport.pdf"
Sheet1.ExportAsFixedFormat xlTypePDF, sPath
End Sub
will produce a PDF file, but if the print range contains images ,graphs, etc. they will be omitted.
Anonymous
shared this idea
Thanks for reporting this issue. The fix for this will be in the next update (v16.13), which should be released in mid-May.
5 comments
-
Kevin Brown
commented
This bug has the potential to greatly negatively impact the value of this product to me. Please fix this ASAP. thanks.
-
Anonymous
commented
please fix this bug. Mac users need to use excel too! This is a huge problem.
-
Anonymous
commented
Please fix this. It would be beneficial to allow images to print. Really messes up work flow.
-
Essie Djafarian
commented
Please fix this bug, it is essential for being able to PDF in order to save on paper and get a proper work flow
Thanks a lot -
Anonymous
commented
I forgot to mention that we are seeing this in 16.11.1 but have been aware of this issue for a few months now.