Search found 3195 matches

by JRL
Mon May 13, 2019 3:40 pm
Forum: Technical / Scripting
Topic: how to remove "macro scheduler" text in message bo
Replies: 4
Views: 3220

Re: how to remove "macro scheduler" text in message box

The following code demonstrates an easy method to change the standard Message > title in an uncompiled script. There is also code to make a standard message modal. This code might be needed because you could not otherwise alter the title of a standard modal message box in an uncompiled script. Messa...
by JRL
Thu May 09, 2019 3:44 pm
Forum: General Discussion
Topic: Position of spaces
Replies: 14
Views: 290

Re: Position of spaces

Sorry, I am pitiful with regex. Jpuziano wrote this one (at my request) and posted it HERE.
by JRL
Wed May 08, 2019 8:51 pm
Forum: General Discussion
Topic: Position of spaces
Replies: 14
Views: 290

Re: Position of spaces

I don't think you need space positions to do this. See code below. Let>str1=I go to Cali today. //Use StringReplace> to clear out any potential punctuation from all strings StringReplace>str1,.,space,str1 StringReplace>str1,comma,space,str1 Let>str2=I won't go to Cali tomorrow. StringReplace>str2,.,...
by JRL
Wed May 08, 2019 8:29 pm
Forum: Technical / Scripting
Topic: Passing VBS variable to Macro Scheduler
Replies: 2
Views: 63

Re: Passing VBS variable to Macro Scheduler

Code: Select all

VBStart
Function IsFolderEmpty (ParemATT)
Dim objFSO, objFolder, objNoContent

'  MsgBox ParemATT



'  Set the function name to the result
IsFolderEmpty = ParemATT



End Function
VBEND
VBEval>IsFolderEmpty(1),Parem
MessageModal>%Parem%
by JRL
Tue May 07, 2019 2:50 am
Forum: General Discussion
Topic: Position of spaces
Replies: 14
Views: 290

Re: Position of spaces

I don't understand what you're asking. If you want to know how to create a variable that contains the data you want displayed in a message look at the script created for your space positions. There is a variable called "vSpacePositions". Notice how it was developed and then used in the script. If th...
by JRL
Mon May 06, 2019 2:03 pm
Forum: General Discussion
Topic: Position of spaces
Replies: 14
Views: 290

Re: Position of spaces

Here's one possible way. Separate the string by internal variable %space%, then get the lengths of the separated words and do the math. Let>vString=I go to Cali today. Separate>vString,space,var Let>vSpacePositions= Let>vTotal=0 Let>kk=0 Repeat>kk Add>kk,1 Let>value=var_%kk% Length>value,vLen Add>vL...
by JRL
Sat Apr 20, 2019 2:31 am
Forum: Technical / Scripting
Topic: Memo Stops Updating
Replies: 2
Views: 139

Re: Memo Stops Updating

"Text" is the Dialog1 MSMemo1 property. Remove "text" from all variables. If the value of "text" becomes, for example, "1234". You have effectively changed
SetDialogProperty>Dialog1,MSMemo1,Text,variable
to
SetDialogProperty>Dialog1,MSMemo1,1234,variable
by JRL
Wed Jan 02, 2019 8:42 pm
Forum: Technical / Scripting
Topic: [SOLVED] HTTPRequest + HTTP_SSL=1 not working?
Replies: 9
Views: 820

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: Technical / Scripting
Topic: Get pid of the process started using RunProgram
Replies: 1
Views: 2682

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: 347

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: 339

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: 665

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: 813

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: 355

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...