Hello and thank you for any help. This is my first project and I’ve gotten a lot farther than I thought I would but now I’m stuck and I can’t figure it out. I’m 99% done and I can’t go any farther without help. In the For Each activity towards the bottom of it I have the following which is supposed to print each iteration of the Excel template into PDF with the variable strAWB as the name of each saved PDF. It’s not working.
May I know at which activity you were getting error
Make sure these stuffs
—enable Simulate click in click activity in the property panel
—similarly for type into activity enable Emptyfield and simulate type property in the property panel of the activity
This will work for sure
Kindly try this and let know for any queries or clarification
Cheers @mworth123
@Palaniyappan - Thank you for your help. The error is on the Click ‘Tab Item Print’ and the please see these images
It’s not so much an error message as a fault.
I have implemented your changes and I’m still getting the same error message in the same place. I simulated click in both click activities. Is that correct? Sorry, can you look again?
@mukeshkala - Thank you again for your input. I am open to anything that will allow this process to work. I’ve plugged in your idea. Don’t I then need the Type Into activity to save the file name as the variable? The variable is strAWB and I need it to save the variable contents as file name in PDF
@mukeshkala - Hello again, I plugged in your idea and it is saving each instance of the template with the same original name and it’s not converting to PDF or naming the file as the variable contents. Please help me to make this work
@mukeshkala - Thank you again Mukesh. I believe I’ve instituted your suggestions and I have a new error:
Can you tell me what I’m doing wrong? Also, I’ve attached the Main if you can take a look at that if it helps. Main.xaml (27.1 KB)
@balupad14 - Thank you, I’ve installed it but I’m not seeing PDF as an option in the Save Workbook or the SaveAs Workbook. How do I use this to save as PDF?
@balupad14 - Thank you, I’ve installed the other piece in your other post. I do see a way to convert Excel to PDF. It looks easy. I’ll let you know what happens. Thank you for this
@Balupad14 - So I’ve inserted your Export Workbook activity in my For Each activity and it threw an error with some hex code. I put a Try Catch around it and the error stopped. The issue I’m having is that instead of converting the template into PDF it is just saving the template in Excel over and over and pasting in the variable for each iteration. I’ve added a couple of images and the Main. Can you see what I’m doing wrong?
