Search found 3187 matches

by JRL
Wed Jan 02, 2019 8:42 pm
Forum: Technical / Scripting
Topic: HTTPRequest + HTTP_SSL=1 not working?
Replies: 9
Views: 558

Re: HTTPRequest + HTTP_SSL=1 not working?

The following code will make the IE window show for an instance, feels a bit flaky for end users. Something like this can mask the window flicker. DeleteFile>%temp_dir%3SecondScreenMask.scp LabelToVar>TemporaryScript,vData WriteLn>%temp_dir%3SecondScreenMask.scp,wres,vData ExecuteFile>%temp_dir%3Se...
by JRL
Sun Dec 30, 2018 6:04 am
Forum: Macro Scheduler Consultants
Topic: Get pid of the process started using RunProgram
Replies: 1
Views: 2240

Re: Get pid of the process started using RunProgram

Here is a Macro Scheduler script subroutine that uses the GetProcessIDs> function to retrieve a list of process IDs for a specified program prior to the program being run by the script, then again immediately after the program has been run by the script. The two lists are compared and the latest pro...
by JRL
Thu Dec 20, 2018 8:08 pm
Forum: Technical / Scripting
Topic: Out of Memory when using DBQuery
Replies: 7
Views: 139

Re: Out of Memory when using DBQuery

I don't have much time to explain today but it seems to me your problem is that you're creating "columns" X "rows" = "number of variables". (5 cols x 1.5 million rows is 7.5 million variables) In my view you need to be writing everything to disk. I like to use the SQLToCSV vbscript found HERE . Afte...
by JRL
Mon Dec 10, 2018 7:12 pm
Forum: Technical / Scripting
Topic: Image Recognition: Is this a Bug or Trial Limitations?
Replies: 7
Views: 162

Re: Image Recognition: Is this a Bug or Trial Limitations?

Look HERE
Second script makes a .PNG file from your selection. The script can be altered to make a .BMP or a .JPG. The script doesn't care what direction you move to make your selection.
by JRL
Tue Nov 13, 2018 9:56 pm
Forum: General Discussion
Topic: Replacing Special Character in Excel Sheet using Macro Scheduler
Replies: 5
Views: 505

Re: Replacing Special Character in Excel Sheet using Macro Scheduler

You could use Macro Scheduler's DBConnect> function. If you know Structured Query Language (SQL) this is a very useful feature. It is my primary method for dealing with Excel files in Macro Scheduler. As an example. The first script below will place a small excel file on your desktop named JRL_Examp...
by JRL
Thu Oct 25, 2018 6:24 pm
Forum: Scripts and Tips
Topic: Loop Macro Running Wile the rest runs As well?
Replies: 2
Views: 669

Re: Loop Macro Running While the rest runs As well?

Here's a sample using a Custom OnEvent> Press Esc key to stop the script. //Cycle time in milliseconds Let>vCycleTime=15000 Let>msg_xpos=300 Let>msg_ypos=300 Message>Cycle counts display here%crlf%every %vCycleTime% milliseconds OnEvent>key_down,VK27,0,Quit OnEvent>Custom,Source,vFlag,Target Timer>v...
by JRL
Sun Oct 21, 2018 4:05 am
Forum: Technical / Scripting
Topic: user32.dll and ShowCursor
Replies: 2
Views: 254

Re: user32.dll and ShowCursor

Try this. Usually Boolean "false" needs to be 0 and "true" needs to be 1. Or rather, "true" needs to be anything other than 0. So the word False gives a plus 1 (true) result with this particular API function. Label>HideCursor LibFunc>user32,ShowCursor,Test,0 If>{%test%>=0} Goto>HideCursor EndIf Wait...
by JRL
Tue Oct 02, 2018 8:31 pm
Forum: Technical / Scripting
Topic: Can you detect a double click?
Replies: 4
Views: 385

Re: Can you detect a double click?

@cvlr,
You're welcome.

@Grovkillen,
No need to be sorry. You summed up the concept succinctly and eloquently. Good job.
by JRL
Tue Oct 02, 2018 7:22 pm
Forum: Technical / Scripting
Topic: Can you detect a double click?
Replies: 4
Views: 385

Re: Can you detect a double click?

There is no function to do that but here is a sample script that uses Notepad as the double click window.. After starting the script, move the message window and the Notepad window to where you can see both. Then you can watch the results of your double click on Notepad in the message window. Edit: ...
by JRL
Mon Oct 01, 2018 9:03 pm
Forum: General Discussion
Topic: Type a TAB in a Dialog
Replies: 1
Views: 334

Type a TAB in a Dialog

Has anyone discovered a method to type the TAB character into a dialog object such as a memo or edit field? Pressing Tab moves to the next field as expected. Pressing ALT + 9 presents a question mark as does ALT + just about any number under 32. My only thought is to specify a special string such as...
by JRL
Tue Sep 25, 2018 3:54 pm
Forum: Beginners
Topic: Autologon with Windows 8
Replies: 1
Views: 273

Re: Autologon with Windows 8

I've never used autologon so I have no first hand experience but I do remember reading the following article and it seems pretty comprehensive.
https://help.mjtnet.com/article/49-inst ... -autologon
by JRL
Fri Sep 14, 2018 7:33 pm
Forum: Technical / Scripting
Topic: StringReplace issue
Replies: 2
Views: 303

Re: StringReplace issue

The issue for cvlr is the third (last) comma. Leave the last comma out and StringReplace> will work without the last result variable parameter. Add that last comma and the function wants you to specify the fourth (result variable) parameter. As for the nullchar issue. The problem is that the macro e...
by JRL
Sat Jul 07, 2018 5:03 am
Forum: Technical / Scripting
Topic: Reaching a divisor function with Macro Scheduler [solved]
Replies: 2
Views: 276

Re: Reaching a divisor function with Macro Scheduler

Don't truly know what you're looking for but this gives the same answer as your example.

Code: Select all

Let>value=95334677

Let>kk=1

Repeat>kk
  Add>kk,1
  Let>res={%value%/%kk%}
  Separate>res,.,item
  If>item_Count<2
    Let>ans=kk
    Let>kk=done
  EndIf
Until>kk=done

mdl>ans
by JRL
Tue Jun 12, 2018 2:30 am
Forum: Technical / Scripting
Topic: Left string command
Replies: 1
Views: 187

Re: Left string command

Maybe I've been using it too long but I don't find MidStr> clunky at all. That said, if you want "left" and "right" functions, you can easily use them in VBScript via VBEval> Let>vStr=ManyPathsToTread VBEval>left("%vStr%",9),res MDL>res VBEval>Right("%vStr%",7),res MDL>res Midstr>vStr,1,9,res MDL>re...
by JRL
Tue Jun 12, 2018 2:02 am
Forum: Technical / Scripting
Topic: System variables in Includefromvar
Replies: 2
Views: 272

Re: System variables in Includefromvar

Code: Select all

LabelToVar>Code,vData

Let>Percent=%

IncludeFromVar>vData

/*
Code:
mdl>Hello %Percent%CRLF%Percent% World!
*/