Unable to save PDF files in specific folder

Help
, ,
1

Dear Experts:

The below folder structure is created already before process. Now after process I will be getting a PDF file for a respective company ( example :- OCBC.pdf), that PDF file should be save in OCBC folder.

image
image591×750 255 KB

But as we can’t redirect it to particular folder, before saving it we need search for the OCBC folder and open it and save it

Process steps:

  1. Read data from excel .

    image
    image880×557 22.4 KB

  2. google each row from that excel

  3. open the 1st 3 url from google and save the pdf

  4. the pdf needs to be saved in exact company folder

Kindly help me

2

@Vadugu try giving the folder path of OCBC directly in the Save As pop up window , while saving pdf , that will open the folder

3

For every run, company name will changes BOT needs to understand the company name and should save it respective company folder.

4

Hi @Vadugu
Does the company name available in excel or in website?

5

In excel

6

@Vadugu
If the company name available in excel, whenever you start reading it save that into variable and while saving the pdf, paste it in the path, for example
In Save As screen: C:\User\Documents\row(2).ToString\Sample1.pdf
You can save it to the separate variable for a better coding: C:\User\Documents
It works dynamically and if the folder is not there it’ll create it on run.

7

I have done that but no luck

8

What’s the error?

9

bot unable to identify the folder ,stop the bot

10

Folder might not be existing…or can you check the path is given correctly.

11

@Vadugu,

please clarify more about your requirements. I have following listed doubts-

  1. Do we have to extract the company name from the excel image you have shared, or there is a separate column depicting company name
  2. Is company name and folder name replicates each other
  3. do we have a particular path for each company, for an example, company OCBC path is ALM–29248–OCBC, or we have to search random for the folder OCBC