Save as pdf excel activity, does not save correctly excel file

Help Robot
,
1

I have dynamically updating excel file, I need to save it as pdf. Locally on my PC it’s saving as I want, but on Robot’s computer it saving one column as one page, whether I need to save entire sheet as a page. I’ve tried to use save as pdf activity and VBA macro. Both methods returning same result. Here’s my VBA code:

Sub SaveActiveSheetsAsPDF(Path As String)

'Create and assign variables
Dim saveLocation As String
saveLocation = Path

With ActiveSheet.PageSetup
        .FitToPagesWide = 1
        .FitToPagesTall = 1
End With


'Save Active Sheet(s) as PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=saveLocation
    

End Sub
2

Hi @abzal.baimukhanov ,

This is a single time activity. You need to login into the Robot machine and perform the save as setting for the excel as you have in your machine. Then you can use save as pdf activity directly.

3

Did you find any resolution here?

4

Nope, I’ve tried many options but still

5

This may be unrelated as your issue is slightly different than ours was… but if you go into the robot machine, open excel and go to print, do you see “Microsoft Print to PDF”?

image