Search found 6 matches

by JohnJ2717
Thu May 18, 2023 3:33 pm
Forum: Beginners
Topic: Site-to-Excel copying cycling
Replies: 9
Views: 15891

Re: Site-to-Excel copying cycling

Well... the trial period is over, but I haven't completed my training yet. I don’t have money for a license, besides, the country is under sanctions, so I will gladly listen to any suggestions.
by JohnJ2717
Tue Apr 25, 2023 3:03 pm
Forum: Beginners
Topic: Site-to-Excel copying cycling
Replies: 9
Views: 15891

Re: Site-to-Excel copying cycling

You can't just paste an array.
Oh,please forgive my carelessness (Besides,all i remember from programming is binary and hex)
Particularly if you try to rush this and run before you can walk.
I'm afraid that's exactly what I was trying to do :? :)
by JohnJ2717
Fri Apr 21, 2023 6:06 pm
Forum: Beginners
Topic: Site-to-Excel copying cycling
Replies: 9
Views: 15891

Re: Site-to-Excel copying cycling

Это Xpath, который вам нужен. В моем тесте он вернул 27 значений из «столбца 2» In my case, it returns <array> to the clipboard, and the command "get cell" does not work at all Maybe I misunderstand how to paste it into the clipboard, or do something else wrong... :shock: In addition, I still did n...
by JohnJ2717
Sat Apr 15, 2023 4:49 pm
Forum: Beginners
Topic: Site-to-Excel copying cycling
Replies: 9
Views: 15891

Re: Site-to-Excel copying cycling

As it says in the help file Thanks, it helps :D It is not necessary at all. I fact copying and pasting to Word just to copy it out again is counter-intuitive. This was necessary due to the impossibility of copying the right column separately from the left one, and now I'm not sure if it's worth aba...
by JohnJ2717
Fri Apr 14, 2023 8:46 pm
Forum: Beginners
Topic: Site-to-Excel copying cycling
Replies: 9
Views: 15891

Re: Site-to-Excel copying cycling

Focuses an existing Chrome Session, selects and copies a table (CTRL-V) Opens Word, pastes the data, then copies the data again Opens Excel, pastes the data right :) There is not an equivalent command for Chrome or Edge, but with a little more work you can extract whatever you like. See Using Macro...
by JohnJ2717
Thu Apr 13, 2023 9:57 pm
Forum: Beginners
Topic: Site-to-Excel copying cycling
Replies: 9
Views: 15891

Site-to-Excel copying cycling

I tried to loop the recorded macro of copying data from the site to excel, but could not figure out how to replace keystrokes with a counter (on the site, data is entered through 0.01 to 2 and 0.1 after 2; in excel, the columns switch to the right 10 times, then skip column and repeat), and actually...
Sign up to our newsletter for free automation tips, tricks & discounts