Get data and copy from chrome to excel

[paulrf]

Hello
I bought your Macro Scheduler pro but i have problem , i am doing a macro with chrome and i have a bunch of questions can you guys answer me .
1. how to open a file automatically after download (excel file, downloaded after using "ChromeFindElements" and click to download on chrome ?
2. how after opening excel file can resize program excel
3 how to move to a cell in the opened excel file and copy the data from that cell to another excel file.
4. how i can get data from chrome and copy to excel , i try ChromeGetElementData but don't go , i want to get only 1 404,39

code :
<td class="row0" style="text-align:right;"><span style="white-space: nowrap;">1 404,39 zł</span></td>

[Dorian (MJT support)]

1. how to open a file automatically after download (excel file)

Wait for the file to download (or loop IfFileExists), Use XLOpen to open the Excel file

2. how after opening excel file can resize program excel

Resize the window? ResizeWindow and if required MoveWindow

3 how to move to a cell in the opened excel file and copy the data from that cell to another excel file.

you've already used XLOpen to open the first Excel file, so then use XLGetCell to read the data from the cell you require. Then use XLOpen to open the second file, and XLSetCell to write to the required cell in the newly opened Excel workbook. Make sure to use a different handle for each workbook opened with XLOpen (reading the pages I linked to will explain that).

4. how i can get data from chrome and copy to excel , i try ChromeGetElementData but don't go , i want to get only 1 404,39

el_1 will be the first match, el_2 the second, el_3 the third, and so on. There may be a better way of doing this but this example specifically relates to the snippet you provided.

Code: Select all

ChromeFindElements>session_id,xpath,//span[@style='white-space: nowrap;'],el
ChromeGetElementData>session_id,el_1,text,TheText
mdl>TheText

Then write TheText to your spreadsheet with XLSetCell.

[paulrf]

Thank you for the answer , can you help me in this case .
There are 1 billion
I have 1 column of data in excel, for example: column A from A1 to A10 contains data that I have to replace the website link, A1 = 123455 access the link of the website abc.com/12345.pdf and download the pdf file Then repeat the process until you find an empty box

[Dorian (MJT support)]

First of all you'd use XLGetSheetDims to find out how many rows there are, and loop that many times.

You should then be able to download the pdf with HTTPRequest :

Code: Select all

let>TheURL=https://www.mjtnet.com/MacroSchedulerManual.pdf
HTTPRequest>TheURL,d:\MacroSchedulerManual.pdf,GET,,HTMLResponse