SRT>RoutineName .. do your functions END>RoutineName if>isSync=TRUE GoSub>RoutineName endif ..basically go to the subroutine called RoutineName if the item isSync is TRUE if not then just ignore the routine and continue on with the script. ie: SRT>DisplayValue Mdl>K value is %k% END>DisplayValue let...

I dont know if this is related but your script might not end,

repeat>k
...
..

until>k,c-1

.. i did a simple notepad paste it pasted no problem.
but it ran endlessly.

maybe change it to:

let>c=c-1
repeat>k
....
..
until>k,c

Hi all, on version 13.2.4, using View System Windows on .Net4 Framework. It picks up the class name and such. But it does not pick up the value inside the control. First load it will pickup whatever the default values are, however, if i search our program and the window's text change, refreshing the...

Hi, This was posted in general discussion, but would be nice to have a return value when the above command is use. This way we can determine if a new sheet added successfully rather than trying to go through vbscript to find if the sheet exist or not. currently, when it failed, you get an error and ...

Thanks Marcus,

Hi, Just wondering if anyone has any suggestion (aside from vbscript). Is there any way to check if an excel Tab exist before trying to create it? XLAddSheet takes 2 parameters, the handle and the name. if I blindly add the name, and the name of the tab exist, it will create a new sheet called "Shee...

Thanks, got the email - works good now.

Found that the GetTextInit is not included into the exe so it will crashed, but cannot find where the information on how to's for compiling it.

SetFocus>Untitled - Notepad GetTextInit GetWindowTextEx>Untitled - Notepad,strText mdl>strText i m getting an application crashed. it runs find when its run inside MS. it will not run even if you leave the script above as a .scp and create another script into an exe use macro to run the script above...

when issuing an XLQuit>xlHandle

any body know if we open up the task manager, Excel.exe, is still in the process?

It does clear the task manager when the script finish, but until the script is done it just sits there.

i m not sure if this is what you are looking for for number 3 and you might have to play or google regex patterns, Let>GFL_TYPE=0 let>initFolder=c:\Users\Temp\ GetFileList>%initFolder%*.*,files,; Separate>files,;,file let>x=0 let>pattern=\r\n repeat>x add>x,1 ExtractFileName>file_%x%,fName ExtractFi...

can you demonstrate how to use extract file name to get a folder name? Below is what i would do. Using stringreplace will help as you already know the starting folder path. Let>GFL_TYPE=1 GetFileList>C:\Users\temp\*.*,folder_list,; Separate>folder_list,;,folders If>folders_count>0 Let>fldr=0 Repeat>...

in that case what is the best option when trying to determine when a variable in an array has a value assign to it or not? let say, i have a query that pulled a 1 long memo. set>sql=select memo from tblMemo where id=123445 dbQuery>dbH,sql,sqlRSt,r,n if>r=1 //there should only be 1. seperate>memo,crl...

ArrayDim>abc,2 let>abc_1=1 let>abc_2=2 let>x=1 what is the differences between using abc_%x% abc_1 example: mdl>abc_1 mdl>abc_%x% gives the same result but: Assigned>abc_1,isAssigned this will result in isAssigned=TRUE Assigned>abc_%x%, isAssigned this will result in isAssigned=FAlSE this is on vers...

i m pretty new to MS but i've run through the same problem using stringreplace to replace comma with a different values. what i came up with: let>comma=, let>replace=. stringreplace>%source%,%comma%,%replace%,source this should assign the , and change it to . in your source string and put it back in...