Print Excel file to printer

Help Activities
, ,
1

Hello i have a problem related to printing
So I have made an automation to process excel file and now I want to print that excel file as a hardcopy using a printer
how can I achieve this? also I want to set a certain parameter when printing (like page orientation, fit to page, etc.)

Thanks in advance

2

@Fauzan_Marantama - You have to build a workflow using Send Hotkey to achieve this…

Refer this post

3

I have tried that, but when i use excel application scope, it doesnt open the excel so i cant use the send hotkey & click activities because the robot cant find the element

4

I will try to build something tomorrow(my time) and will share with you.

5

Thank you, highly appriciated

6

@Fauzan_Marantama - Please find the starter help here…

Excel to Print.zip (8.1 KB)

Currently upto ctrl+P is working, from here you can use click and select activity to pertinently to play with various printer options to printer the file.

7

For the attach window activity, It select the excel windows based on the name of the excel file
In my case the excel file can use different names, how can i make the selector know the name of the excel file?

8

@Fauzan_Marantama - Nope…Below is the screenshot of my current attach window…

image

So if you have dynamic file name, then simply pass that variable in the excel application scope, then that particular file will be opened and process will be continue…Please try this and let me know, if you need any help…

9

Still not working, but after pass the excel name into variable and then use it on the selector editor I can make it work

Thank you

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.