Save Excel template as PDF with a varying name

Help
,
#1

Hello and thank you in advance. I am new to UIPath and here is my issue. So far I have figured out how to
open a website
scrape all of the data to a data table
Use a for each loop to pull the waybill number from the data table and save it to an Excel template called “DS LOA Template.xlsx”
Here is the issue:
**Now I need to save the template to PDF using the waybill number which changes each time. The variable is called “awb” without quotes of course **
An analyst friend of mine suggested using the Type Into activity but I can’t figure it out
Can anyone shed some light? Thank you in advance

#2

Hi @mworth123,

Welcome to the community.

Here’s what you can do.

  1. Use 'Send Hotkey activity and press f12
  2. Use Type Into activity and write the path where you want to save the document > add AWB as your variable
  3. Then save the doc in PDF.

Let me know if this works.

#3

Thank you for the quick reply!
I’ve done steps one and two in your message. How do I save as PDF?