Search found 601 matches

by Dorian (MJT support)
Mon Mar 30, 2020 5:02 pm
Forum: Beginners
Topic: View System Windows
Replies: 1
Views: 23

Re: View System Windows

WaitReady might do the job here. If you're looking to use SetFocus for "200230 DroverLord - Window Class "DroverLord" - Frame Window" you could do something like this : //You may also need to try one of these : Let>WF_TYPE=3 - Child Windows Only Let>WF_TYPE=0 - No Child Windows Let>WF_TYPE=1 - ALL ...
by Dorian (MJT support)
Mon Mar 30, 2020 4:43 pm
Forum: Technical / Scripting
Topic: Saving generated excel
Replies: 5
Views: 44

Re: Saving generated excel

Excellent! Great to hear. Thank you for the feedback.
by Dorian (MJT support)
Mon Mar 30, 2020 10:44 am
Forum: Technical / Scripting
Topic: Saving generated excel
Replies: 5
Views: 44

Re: Saving generated excel

I'm not 100% sure i follow, but let's see. If I edit part of your script slightly, to make sure varLocatie is as it was entered, we see that all is as expected. ...... Else MessageModal>User Cancelled Endif //MJT edit MessageModal>varLocatie exit Press F12 Wait>0.1 SendText>Name file ..... So is the...
by Dorian (MJT support)
Mon Mar 30, 2020 10:17 am
Forum: Beginners
Topic: Resize Images
Replies: 11
Views: 99

Re: Resize Images

This is worth delving in to. :) It works for me both with the quotes Marcus added, and without them. However, that may be because I don't have any spaces in my file paths. All these methods work - for me : Let>RP_WINDOWMODE=0 let>TheFile=d:\MJT\files\images\ImageA.gif let>IMPath=C:\Program Files\Ima...
by Dorian (MJT support)
Thu Mar 26, 2020 2:19 pm
Forum: Beginners
Topic: Resize Images
Replies: 11
Views: 99

Re: Resize Images

Support is quiet here at the moment so I was able to put some time into this for you. You should be able to use it as a template and to understand the methods I used. I created the VBA by recording a macro in Excel. Then copied the VBA into the script, with minor editing. As you can see, we can use ...
by Dorian (MJT support)
Wed Mar 25, 2020 11:33 pm
Forum: Beginners
Topic: Resize Images
Replies: 11
Views: 99

Re: Resize Images

Do you mean insert the actual images? Or the image names? I haven't tried it but if it's the actual images I'd probably start by looking at XLRunCode.
by Dorian (MJT support)
Wed Mar 25, 2020 4:15 pm
Forum: Beginners
Topic: Resize Images
Replies: 11
Views: 99

Re: Resize Images

Something like this. It'll resize images using ImageMagick. Be careful, the script below will overwrite the files it finds. I'm just using this as a simple example of ImageMagick usage. IM is very powerful once you delve into it, and I'm sure there will be a way of resizing the images how you want. ...
by Dorian (MJT support)
Wed Mar 25, 2020 3:45 pm
Forum: Beginners
Topic: Resize Images
Replies: 11
Views: 99

Re: Resize Images

I've done this with great success using Macro Scheduler with ImageMagick via command line. I used GetFileList to get a list of thousands of images in a folder, and then ran through each one with imageMagick.
by Dorian (MJT support)
Tue Mar 24, 2020 12:09 am
Forum: Enhancement Suggestions
Topic: TimeDiff interval check
Replies: 2
Views: 40

Re: TimeDiff interval check

Single letter variable assignments should be avoided, and this is one very good reason why. We see this quite often when people are reading from Excel and they'll assign a variable according to the column they're reading. Col_S would be a lot less dangerous than simply S, for example.
by Dorian (MJT support)
Mon Mar 23, 2020 1:11 pm
Forum: Enhancement Suggestions
Topic: Chrome Driver - Traverse Iframes & Insert HTML
Replies: 24
Views: 933

Re: Chrome Driver - Traverse Iframes & Insert HTML

Well, since we were working on this anyway and it was further ahead than I thought, I managed to reprioritise a few things and get an update pushed out today with added native ChromeSwitchFrame and EdgeSwitchFrame functions. Version 15.0.07. Available in the usual places. Again, if this is somethin...
by Dorian (MJT support)
Thu Mar 19, 2020 4:10 pm
Forum: General Discussion
Topic: Connecting to Oracle through Macro
Replies: 1
Views: 67

Re: Connecting to Oracle through Macro

There's a lot of info regarding Oracle in this forum. I suggest starting with this thread.
by Dorian (MJT support)
Fri Mar 13, 2020 3:00 pm
Forum: Beginners
Topic: Gathering info on amazon
Replies: 3
Views: 2141

Re: Gathering info on amazon

Try IEWait instead. I'll often use IEWaitForText and a little Wait afterwards to be sure.
by Dorian (MJT support)
Tue Mar 10, 2020 3:26 pm
Forum: Beginners
Topic: Gathering info on amazon
Replies: 3
Views: 2141

Re: Gathering info on amazon

I'd start off by seeing if you can extract the elements you're looking for with the Find IE Element Wizard . Maybe also see if IEGetAllText will extract what you're looking for, which can then be parsed. Those are starting points, but experimentation is the key. You'd probably need to start with a l...
by Dorian (MJT support)
Tue Mar 10, 2020 10:47 am
Forum: Beginners
Topic: passing numeric variable in a file name
Replies: 1
Views: 277

Re: passing numeric variable in a file name

Use Desktop_dir, like this : OCRArea>694,184,793,218,strText Year>yyyy Midstr>yyyy,3,2,yy Month>mm Day>dd Let>FileName=%desktop_dir%\sample_%strText%_%dd%-%mm%-%yy%.txt WriteLn>FileName,result,strText //Will create ..._10-03-2020.txt Let>FileName=%desktop_dir%\sample_%strText%_%dd%-%mm%-%yyyy%.txt /...
by Dorian (MJT support)
Mon Mar 09, 2020 10:59 am
Forum: Technical / Scripting
Topic: Numeric strings returning with "," decimal seperator
Replies: 2
Views: 57

Re: Numeric strings returning with "," decimal seperator

Hi Scones, did you know you can set these variables?

DECIMAL_SEPARATOR
THOUSAND_SEPARATOR
Sign up to our newsletter for free automation tips, tricks & discounts