Macro Scheduler Forums

hagchr

In this case SetDialogProperty> needs to come before ShowDialog>. (The comma in Show>Dialog1, will make the dialog modal and execution will halt until the dialog is closed, ie it will not reach the SetDialogProperty until it is too late in your example).

hagchr

Caption is just a parameter so very easy to change (eg use SetDialogProperty>) For the buttons, one way could be to generate the buttons dynamically based on the Excel file, another way (easier) could be to create the 40 buttons in your dialog (with proper placement etc) and then you read the excel ...

hagchr

Wouldn't it be possible to change the object names if you put the dialog code into a label and then use LabeltoVar> to get it into a variable, then do the adjustments (buttons, names, captions etc) through some string work and finally use IncludefromVar> and Show> to get the modified dialog? (ie cha...

hagchr

Hi, Try to use Message>xx instead, then you should see the text (Send>xx will just send xx to the active window which will not work in your example).

hagchr

Hi, this would be a simple way to do it. Hope it helps. //For illustration, data is read from label LabelToVar>List,StrData,1,0,{"*/"} //To read data from file use "ReadFile" instead and comment out / delete the "LabelToVar" above //ReadFile>C:\...\datafile.csv,strData Separate>strData,%CRLF%,strRec...

hagchr

Hi, thanks for the reply. I modified the original code to your test string and changed the name to My_ARR and it still works fine. Key if you use this method is to keep the two regexes - one at the beginning of the SRT and one at the end which gives the unresolved array names, ie Gosub>calc,"My_ARR"...

hagchr

Hi, in VBS / Excel there is a range property - FormulaArray - that can be used to define an array formula, in the case below placing it in cell "E8" in "Sheet1" in "test.xlsx". The original formula had to be modified slightly to avoid confusion with the quotes. Hope if helps. VBSTART Sub updExcel Se...

hagchr

Thanks JRL for opening my eyes for StringGrid. I am now trying to figure out the various parameters. Some implementations of StringGrid seem to have a Cells[row][column] kind of property to easily access individual elements. I think that is what you suggested and also seems to be on the list. In the...

hagchr

Sorry, was too fast, in this case you can simplify it more.

Code: Select all

Let>personaje=1
Let>xdelpersonaje[1]=340
Let>x=xdelpersonaje[%personaje%]

hagchr

Hi, I guess you want to do this:

Code: Select all

Let>personaje=1
Let>xdelpersonaje[1]=340

Let>tmp=xdelpersonaje[%personaje%]
Let>x=%tmp%

hagchr

An alternative approach for anyone interested in RegEx. It is probably an over-kill for smaller data sets but could well be worth it for larger ones (seconds instead of minutes in terms of runtime). It is based on the info provided in the post so would possibly have to be adjusted if the actual file...

hagchr

Sorry no intention to mix the posts. I get the issue from time to time when debugging but since the code works fine I just thought it was some kind of display problem on my side. just got the impression the previous poster had a similar issue with a blank line.

hagchr

Hi, not sure if this is the same thing but the following code runs well but when I step it through line by line then the extract line looks empty (cannot find resTag anywhere). However, if I copy the line to NotePad the extract is there ok. IECreate>IE[0] IEShowIE>IE[0],1 Let>URL0=http://bors.affars...

hagchr

If one add a step to the first piece of code then it seems to work.

Code: Select all

Let>clip=0
Let>max=10
Let>bool=>

Let>condition=%clip%%bool%%max%
Let>Test={condition}

If>Test=TRUE
 MessageModal>greater
Else
 MessageModal>smaller
EndIf

hagchr

New version works great, many thanks for the update.

Search found 327 matches

Re: Naming buttons in Dialog with array info

Re: Naming buttons in Dialog with array info

Re: Naming buttons in Dialog with array info

Re: hotkeys not working latest version - official

Re: Modify Field In CSV File

Re: "Pass" Array to SRT

Re: xlsetcell as an array...

Re: Read and Write StringGrid Cell?

Re: variable inside variable

Re: variable inside variable

Re: XML to CSV convertion

Re: Watch List issue with long lines - was Reading ini files

Watch List issue with long lines - was Reading ini files..

Re: the boolean operator in a variable

Re: Issue with CodeBlock in v14.2