3 weeks ago
Hi,
Im trying to export my Excel as PDF but it´s not working..
I downloaded the latest Excel VBO but and even tried the extended with no success.
My inputs: (which should be fine because they work with all the other actions..)
Error:
@ewilson 🙂
All help appreciated.
Best regards,
Karl
Answered! Go to Answer.
3 weeks ago
Have you verified that you can manually export as PDF in Excel for that specific file first?
3 weeks ago
I believe that's a NAME_NOT_FOUND error in Excel. This could be caused by any number of issues within the Workbook itself. First thing I'd try is setting the Active Sheet Only flag to True and see if that exports ok.
Cheers,
Eric
3 weeks ago
Have you verified that you can manually export as PDF in Excel for that specific file first?
3 weeks ago
I should have tried this first.. Didn´´t think it could be an issue but there´s a problem when trying to do it even manually but i get this:
Any suggestion on work around?
When i tried to use the Save As PDF in the other object i get an issue with the Portrait / Landscape input where i tried both True/False without success.
3 weeks ago
@karl.hansson I haven't seen that specific error before (the one dealing with no printers installed). I would think all it wants is Microsoft Print to PDF set up as a Printer. Do you have that in your list of printers? Maybe if you set it as default in the printers, then it might work? Also, make sure the Print Spooler Windows service is running.
2 weeks ago
Dear @karl.hansson
I have faced the similar issue with my Remote Desktop Machine. I was able to convert Excel to pdf in my local desktop but when it comes to RDP I'm getting the same error.
I suggest you to check the excel version and update it to the newer of excel this will resolve your issue
2 weeks ago
@faheemsd and @karl.hansson contact your security/infrastructure department.
Ask them about policy for "print spooler" service, excel uses it for export (the "export" is actually the same thing as printing to PDF). This Windows component is ussually forbidden at servers and virtual machines as it presents a security risk (and you don't ussually have any printers connected there anyway).