Search found 922 matches

by Dorian (MJT support)
Thu Apr 08, 2021 3:14 pm
Forum: General Discussion
Topic: Dialog Editor off the screen
Replies: 8
Views: 797

Re: Dialog Editor off the screen

Grovkillen wrote:
Thu Apr 08, 2021 3:13 pm
viewtopic.php?f=2&t=10878
That's exactly the thread I was looking for. Cheers! :)
by Dorian (MJT support)
Wed Apr 07, 2021 10:17 am
Forum: Scripts and Tips
Topic: Assigning keys to other keys.
Replies: 0
Views: 379

Assigning keys to other keys.

Three or four years ago I had a keyboard with a Menu key on it. Think of it as a "right-click button". I don't like repeatedly having to use my mouse for right-click when I could so easily "press right-click" then choose a shortcut key. The trouble is, most keyboards don't have that button. Enter Ma...
by Dorian (MJT support)
Wed Apr 07, 2021 10:05 am
Forum: Scripts and Tips
Topic: Chrome Bookmarks script
Replies: 0
Views: 304

Chrome Bookmarks script

I thought this might help some beginners out there. Two of the things I dislike the most are using my mouse when I don't have to, and fishing around trying to find certain bookmarks. I know it's only a few seconds, but I use bookmarks multiple times per day. One thing I learned years ago is that we ...
by Dorian (MJT support)
Tue Apr 06, 2021 2:54 pm
Forum: Beginners
Topic: XLGet Active Workbook
Replies: 12
Views: 602

Re: XLGet Active Workbook

If you wanted every 10th row wouldn't you just simply use Let>v=v+10?

There would probably be an overlap so you need to stop when v > compte.

Until>v>%compte%
by Dorian (MJT support)
Tue Apr 06, 2021 11:06 am
Forum: Beginners
Topic: XLGet Active Workbook
Replies: 12
Views: 602

Re: XLGet Active Workbook

That is a strange one, and without being able to experiment with it I can't think of an obvious way. Have you tried the OCR wizard? Tbh if this was me and I was having reliability issues extracting text I'd probably go the download Excel route too. Do you have that method working now? Either with XL...
by Dorian (MJT support)
Mon Apr 05, 2021 9:35 pm
Forum: Beginners
Topic: XLGet Active Workbook
Replies: 12
Views: 602

Re: XLGet Active Workbook

Eurgh. Why don't you send the xlsx file to us over at Support and we'll have a play with it. I'm guessing the reason you're using XLSheetToArray is because you don't have Excel installed? Otherwise you'd have all the other XL options to play with and not need the file to be an xls as opposed to an x...
by Dorian (MJT support)
Mon Apr 05, 2021 6:33 pm
Forum: Beginners
Topic: XLGet Active Workbook
Replies: 12
Views: 602

Re: XLGet Active Workbook

I had a play with it and it doesn't seem to like 16, or a few of the others. It seems to work with 39, or nothing. XLSave>xlBook,d:\mybook.xls,39 XLSave>xlBook,d:\mybook.xls However, only the 39 option produced a file readable by XLSheettoArray. My test sheet simply contained 3 row and 2 columns : A...
by Dorian (MJT support)
Mon Apr 05, 2021 12:56 pm
Forum: Beginners
Topic: XLGet Active Workbook
Replies: 12
Views: 602

Re: XLGet Active Workbook

Just to add to what Grovkillen said, another alternative if the file is already open is XLGet.
by Dorian (MJT support)
Thu Apr 01, 2021 5:03 pm
Forum: Technical / Scripting
Topic: fsStayOnTop not working
Replies: 3
Views: 312

Re: fsStayOnTop not working

Cheers JRL. We can always rely on you in a pinch. :)
by Dorian (MJT support)
Thu Apr 01, 2021 1:38 pm
Forum: Technical / Scripting
Topic: fsStayOnTop not working
Replies: 3
Views: 312

Re: fsStayOnTop not working

fsStayOnTop sometimes presents us with a conundrum. There really is no such thing as stay on top in Windows. fsStayOnTop is a fudge. Windows doesn't let apps force themselves to the top.

Also what if you have two windows that set themselves to stay on top?
by Dorian (MJT support)
Thu Apr 01, 2021 10:42 am
Forum: Technical / Scripting
Topic: Change download folder and file name on chromedriver
Replies: 9
Views: 497

Re: Change download folder and file name on chromedriver

I was experimenting with this a little while ago, and didn't manage to find a way. There are some great mind here though, and some of those have delved quite deeply into ChromeDriver options. I'd be doing it the same way you already are unless someone finds a way to do it. The question in the meanti...
by Dorian (MJT support)
Tue Mar 30, 2021 4:53 pm
Forum: Beginners
Topic: ChromeFindElements Button click not working
Replies: 10
Views: 563

Re: ChromeFindElements Button click not working

A sizeable part of automation is experimentation. Partly because we're often working on something different. And sometimes something unexpected just seems to make something work. That's the first time I've tried doing it that way, and I don't even know why I tried it. I guess it's just another possi...
by Dorian (MJT support)
Tue Mar 30, 2021 2:58 pm
Forum: Technical / Scripting
Topic: SOLVED: CHROMEDRIVER_OPTIONS exclude switches
Replies: 3
Views: 293

Re: SOLVED: CHROMEDRIVER_OPTIONS exclude switches

That's quite a discovery you made there!

I'd tried Let>CHROMEDRIVER_OPTIONS=disable-infobars hoping in vain that would remove it.

I'd read about it in vasious places, but it doesn't seem to be in this quite exhaustive list : https://peter.sh/experiments/chromium-c ... -switches/
Sign up to our newsletter for free automation tips, tricks & discounts