Search found 965 matches

by Dorian (MJT support)
Thu Sep 16, 2021 4:29 pm
Forum: Technical / Scripting
Topic: Let>NumFound=0 Fails
Replies: 4
Views: 74

Re: Let>NumFound=0 Fails

We've all done it at some point.
by Dorian (MJT support)
Thu Sep 16, 2021 8:08 am
Forum: Technical / Scripting
Topic: Trouble writing to Excel using Macro Scheduler
Replies: 1
Views: 30

Re: Trouble writing to Excel using Macro Scheduler

I'm not able to help with vbscript, but whenever you're working with Excel it's far easier to use the native Excel commands. I recommend reading about XLGetCell for reading cells, XLSetCell for writing to cells, etc.

You can find all the Excel commands here.
by Dorian (MJT support)
Mon Sep 13, 2021 4:57 pm
Forum: Technical / Scripting
Topic: Min or Max?
Replies: 2
Views: 62

Re: Min or Max?

No, but you could always use ArraySort and then take the first or last values. (A rather genius idea courtesy of Marcus).
by Dorian (MJT support)
Tue Sep 07, 2021 11:42 am
Forum: Technical / Scripting
Topic: XLBOOK=ERR: File does not exist
Replies: 3
Views: 74

Re: XLBOOK=ERR: File does not exist

No worries at all. Well done for finding the error.
by Dorian (MJT support)
Tue Sep 07, 2021 7:41 am
Forum: Technical / Scripting
Topic: XLBOOK=ERR: File does not exist
Replies: 3
Views: 74

Re: XLBOOK=ERR: File does not exist

Remove the % from the first line. Macro Scheduler will think that's a variable, and of course that variable does not exist.
by Dorian (MJT support)
Sat Aug 28, 2021 5:16 pm
Forum: Technical / Scripting
Topic: How to convert number to string?
Replies: 5
Views: 169

Re: How to convert number to string?

If you're replacing a comma, you have to use the system variable "comma" because commas are what separate the parameters in Macro scheduler commands. Let>SPX=150 Let>SPX=SPX+0,001 Msg>%SPX% Wait>1 Let>string=%SPX% Msg>%string% Wait>1 StringReplace>string,1,9,pippo Msg>%string% %pippo% StringReplace>...
by Dorian (MJT support)
Sat Aug 28, 2021 2:31 pm
Forum: Technical / Scripting
Topic: How to convert number to string?
Replies: 5
Views: 169

Re: How to convert number to string?

If you're simply trying to replace the comma with a dot, use stringreplace.
by Dorian (MJT support)
Sat Aug 28, 2021 10:32 am
Forum: Technical / Scripting
Topic: How to convert number to string?
Replies: 5
Views: 169

Re: How to convert number to string?

If you want the URL to be something like https://www.xxxxxx.com/100,70 and the user enters 100,70, couldn't it simply be something like this? Let>TheURL=https://www.xxxxxx.com Input>CC,Insert number Let>NewURL=%TheURL%/%CC% Regarding navigation, by far the best way is IENavigate / ChromeNavigate / E...
by Dorian (MJT support)
Fri Aug 27, 2021 11:01 am
Forum: General Discussion
Topic: Scheduler (not working?)
Replies: 1
Views: 77

Re: Scheduler (not working?)

I think you guessed right when you mentioned the screensaver. If you go to this page you'll see "A Note About Screensavers" at the bottom.
by Dorian (MJT support)
Fri Aug 27, 2021 10:56 am
Forum: Technical / Scripting
Topic: MOVE SCREENING -- LDOWN LUP
Replies: 5
Views: 147

Re: MOVE SCREENING -- LDOWN LUP

I wonder if the Messages are interfering with it? I'm not sure why they interfere one way but not the other. Could it also be that whatever you're selecting only allows you to drag/select in one particular way? If I use Paint as an example, remove your Inputs for sake of testing, and remove the Mess...
by Dorian (MJT support)
Wed Aug 25, 2021 4:48 pm
Forum: Technical / Scripting
Topic: MOVE SCREENING -- LDOWN LUP
Replies: 5
Views: 147

Re: MOVE SCREENING -- LDOWN LUP

I think the language barrier confuses things for me so this is hard to understand, but... if I enter 100 as the first value and 3000 as the second, with my resolution being 3840(X) and 2160(Y), it moves my mouse to 3790,2159. So it seems to be moving almost all the way across the screen, which seems...
by Dorian (MJT support)
Mon Aug 23, 2021 10:01 am
Forum: Technical / Scripting
Topic: Unrecognized images
Replies: 2
Views: 113

Re: Unrecognized images

I'm not sure how it would have been working before as you seem to have all sorts of code missing. I suggest running it through the Find Image Wizard again to regenerate the code. Also don't forget the Endif after the If. It should look more like this : ScreenCapture>1160,96,1240,140,D:\LAVORI\_ARDUI...
by Dorian (MJT support)
Thu Aug 19, 2021 1:49 pm
Forum: Technical / Scripting
Topic: Automating a web application via chrome
Replies: 1
Views: 87

Re: Automating a web application via chrome

Please take this direct to support and we'll see how we can help.
by Dorian (MJT support)
Wed Aug 18, 2021 11:21 am
Forum: Technical / Scripting
Topic: Count *.tif files from today in all subdirectory's
Replies: 5
Views: 183

Re: Count *.tif files from today in all subdirectory's

Powershell isn't in my repertoire, but maybe you can save it to a .bat file and then run that?

I know there are others here who know Powershell and vbs too.
cron
Sign up to our newsletter for free automation tips, tricks & discounts