Leaderboard

@Laurynelis Hmmm... IDK. Must be an issue with stripping the path in __WD_CloseDriver. I'll try to check it out in a bit.

Wanted to add, if it's too much bother to convert, maybe you can: - Change the Excel file to xlsm (Macro Enabled) - Insert a module - Copy paste this code - Change "Private" to "Public" at sub declaration (1st line) - Change sub name to whatever (1st line) - and call this sub from AutoIt

This works for me in Excel VBA. I will leave converting to AutoIt to the experts here. Assuming the Header you are looking for is "SamAccountName" Private Sub Table_Test() ' Declare variables Dim wb As Workbook Dim ws As Worksheet Dim rRange As Range Dim TableName As ListObject ' Set variables for Workbook, Worksheet and Data Range Set wb = Application.Workbooks("YourWorkbookNameHere.xlsm") Set ws = wb.Sheets("WorkSheetNameHere") Set rRange = ws.Range("A1").CurrentRegion ' Check if Data Range is already a table If rRange.ListObject Is Nothing Then ' If not a table, add range as new table Set TableName = ws.ListObjects.Add(xlSrcRange, rRange, , xlYes, , "TableStyleLight11") Else ' If already a table, set variable for it Set TableName = rRange.ListObject End If ' Sort all, with column header = "SamAccountName" With TableName.Sort .SortFields.Clear .SortFields.Add Key:=Range(TableName.Name & "[[#All],[SamAccountName]]"), _ SortOn:=xlSortOnValues, _ Order:=xlAscending, DataOption:=xlSortNormal .Header = xlYes .MatchCase = False .Orientation = xlTopToBottom .SortMethod = xlPinYin .Apply End With ' Clean up, set variables Set TableName = Nothing Set rRange = Nothing Set wb = Nothing End Sub Edit2: Added VBA style comment lines

This may work if the random number is always bigger than 999. $sButton = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, "//button[starts-with(@onclick, 'Brandname.saveAmount(') and number(substring(@onclick, 22, 4)) > 999]")

@NguyenDuc Any reason that you can't use the button's text to uniquely identify it? Try this -- $sButton = _WD_FindElement($sSession, $_WD_LOCATOR_ByXPath, "//button[contains(text(),'Luu')]") P.S. Questions of this nature should really be posted in this thread instead of here.

v0.3.1.0 has been released with the following updates -- Changed: Cleanup _WD_DownloadFile Revise error list in header Remove leftover $_WD_HTTPRESULT coding Return $_WD_ERROR_NotFound instead of $_WD_ERROR_InvalidValue Changed (_WD_WaitElement): Added optional parameter to return element instead of 0/1 Chore: Update function headers (Danp2 and seadoggie01) Fix (_WD_Screenshot): Edit return value for Base64 screenshots (seadoggie01) Fix (_WD_WaitElement): Clear variable holding element ID if visibility or enabled check fails

The wiki has a section about Excel automation. Even about formatting. If you need further assistance, just post here. Creating tables is not covered by the Excel UDF that comes with AutoIt. But you could record a macro while you create your table. This can then easily be translated to AutoIt.

To get the best chance of getting help in this forum, I would suggest a few things : 1- Make your code runable. The code you provided is obviously unrunable for any of us. 2- Make your code as small as possible. The code you provided is way too long and contains many steps that are useless to us and to your issue. 3- Provide files example if needed. 4- Use this tool when you post code. 5- Show exactly what is the problem (by using comments inside the code for example) Good luck.

There is an extraneous comma before the final square bracket.

So why didn't you make the changes I suggested at the end of the lines? Just use the lines I posted in the codebox with a cut&paste. That will get rid of your errors. By the way: First get your script running correctly before compiling as that doesn't do a complete check of your code. Jos

Post your script as I doubt that is the issue.

You need to add the line continuation character at the end of the line " _" Global $pessoas = ["__faabss","__gracedufonseca","_angelica_silva2","_antoniosj","_arthurmarcelino","_edi_wilson_","_felipeecabral","_gustavo_rodrigues__","_gustavomunizz","_hortenciia","_isabella003","_italogama","_jessy.oliveira_","_nataliasantos8","_rsiilvaa_","_steffan_02","_vitinhooliveira01","_waltorres","aannylima_","abeelfelipe","adelmo_almeida","adjacksonsheldon","adozrocha","adrianaarjo","adryannao","albereees_jr","aldreyoziel","aleson_barbosa","alexandrafmello","alexandrodavi","alexsioli","aliiciassis","alinemedheiros","alinemelquiades13","alineoliveiras__","alinetorresh","alissonlso","alissonvasconcelos92","allineav","alysonandrade142","alyssa.vasconcelos","amandajotadequeiroz","amandakaroliiny","amandinhaa_eiras","ana.daisy.adylla","andao_","anderson.afp","anderson.carlos01","anderson200o","andersonbrunoss","andersonfonseca._","andersonguialmeida","andersonlacerda323","andersonnerib","andersontenorios","andersonwrangel","andrebunzen","andrecarlos.93","andrelucasdrummer","andremartinadestrador","andresafsales","andressa_ray_lima","angelica2504tony","aninha_lins02","annabeco","anndrezaam","annievlessa","antoniovenancio","ap_205home","apogba_98","apsinline","aquilesxy","arafacavalcante","arlesonivison","armandopvasco","arq.luannaoliveira","arthur.justino","arthur_artbs","arthur_monteeiro","arthurziinsouza","artur.osantiago","aryenne_ferreira","arysoares10","augguerra","augusto.araujjo","auguustolima","avelin0bruno","aylamerencio","baahcristina","babinascimento_","barbaraaveiga","barbaracaroline_.15","barbaragabriela28","barbeariadiluna","barbeirodiogoleite","barros_nane","bcccintra","beaatrizarruda","becoluciana","bekinhafidelis","belaaugusto","bele.medeiros","belle_medeiros2","bellimelo","bellinhalopes","bergueroots","bernardesge","bethcarreiro","betoangotti","bhiafreitas","biabw_","biah.castro_","big.j.soares","biigodegrossoo","binhosemcrause","biroribeiro","boa06_","bonfimtm","boscomedeiro","brayan_barons","bruh_liins","bruhnaninhaa","bruiizidio","brunaaferrazz","brunaizidiopersonal","brunnohellcife","bruno.araujo.fisioterapeuta","bruno_leeeo","brunoaraujo9675","brunodarce","brunofreire.s","brunotrinn","brunovitorpires","btz_santiago","bush_tattoo","caabracurioso","caabradapestee","caabramacho","caanhotto","caarolribeirosilva","caio_ernandes95","caioamorim031","caioanf","camii.araujoo","camila.gueiros","camiladslima45","camilamilico","campeloisabelle","camspimentel","caprichei_feltros","carlosbffilho","carlosh1l","carlosmeira","caroldantas21","caroline_ardila","carolribeirofficial","casth__","caugusto.jr","cecihealthylife","celio.braganca.jr","cezarratis","cibele_freitas23","cintiasantana2641","claarissal","claudinholins","cleydsoncalled","cleyton.cardoso.50","coeelho93","corre.hemir","crisrdl","crystianleao","cunha.n.s","cwespinola","d1ogoluiz","danicardooso_","daniel_alima","daniell_moura_","daniellakuhn","daniellilemoos","daniellyregopersonal","danielmbraun","danielnicope","danilo.s0uza","danilo.svieira","danilo_cdias","daniloamedeiros","danilocuia","danmariiz","dannibarrooos","danyelacan","daschagas.leo","davee.manuel","davi_obliviate","david.januario","daviprolim","dayaneesilvaa_","dayanemenezes92","dayfbc","dayvison38","dayvson_l","dayvsonsantos_","dayzatavares","ddumarques","delianecavalcante","delly_maceedo","denicioribeiro","deniis_henrique","denis.oliveiraa","derciovinicius","deyvison_rafael_","di.mkt","dias_pablo14","diego.lira95","diegomatheusdiniz","diegoshogun","dihbrinks","dinhoafn","diogobads","diogocassimiro.s","diogolima_b","dioguin061","disouza_27","doiogoleal","donthiagobarber","doug.asilva","douglaasantos","douglas_oficicial","douglaslins_","douglaspencanha","drommar_","dryangela","eaee.manu","eden.coelho","edinelson_fr","eduardaagalvao_","eduardogoncvs","eduardovfo","edvaldo_.junior","eidannyferreira","elbadayane","elicabral72", _ "elienayflorencio","elliecarolb","eloisa_amorim","eltonlinconl","emerson.rodrigo","equalisaaa","erasmo_junioor","ericaln90","ericjf","ericmoraess","ericroots","erivan_ns","esdras.monteiro","esdras_domingos23","esdrascavalcs","eu_kessjones","evellyn_paty","everaldo.92","everaldorufino","evoathiago","ewers0n","ewerton_max","f.knust","f.matheus96","fabiobenevides","familia_de_rua","fatimabento98","fdo_luna","fecallou","felipe.gteixeira","felipe.tadewald","felipealbuquerquefts","felipeleandropessoa","ferdinandoshow","fern4nda.fs","fernandaamandahardman","fernandosardinha","ferreiralakers","ferreirataais","ffernanda_diass","filhinhavalentim","fillipeduart","fillipelopez","flaviis__","flavio.sf25","flaviotkd","flaviovansantos","fotografia.edencoelho","fqvinny","frederico.g.nascimento","fuelforliv","fylipnyo","g.filipe","g.salomao","gab1pesso4","gabbana_c","gabrie1silva","gabriel.vitor23","gabrielamouram","gabrieldaraujo_","gabrielgondim_","gabrielrocha9917","gabrielzanfa","geisapazian.nutri","geoge_232","george_marcone","geraldojrfigueiredo","gessicadislaynne","gihbernardes","gilvanvj","giovannabriano","gisele.carvalhoo","gisomarjr1994","giuseppe_fregapane","givacastiliano","glarkson","gleybinhogta","gomesgabriella","gomesjesica","goncalomsneto","gourmeto_","graziinh","guilherme.matheus.correa","guilherme_m_correa","guilhermehenriquew","guilhermelucass_","guilhermepenna","guimelo_96","gustavo_cardozo_araujo","gustavohmcaldas","gustavosbastos","gyzellegueiros","halyson.ribeiro","harlan.pierre","heitordearaujo","heloyzasstefanny","henriquedreyer","henriquee_gomes","henriquenet0","heve_rtonliima","hevertoonlima","heytaamy","hidane","hieduardaa","hranysouza_","icarolenon","ido.lima","ierddan","igordias.jpeg","igorjaless","igorlafaietee","igorpontesb","ijdelima","indialittlee","inegcecilia","isaac.bastos","isabelaferreira77","isabelleamancio","isagomeez15","isatisfatorios","itallocarvalho10","italocruz.edf","italomorais_13","itamaracapernambuco","ittalobarbalho","jairo_pessoa","jamarysantana","jamessonrodrigues6","jamillycarneirofisio","jamiphy","janinedanielly","janinny_pessoa","jardellvictor","jeancbbs","jeffbenicio","jeffersonlima_93","jehgonusii","jennyfermnq","jeronimo.nscto","jessica.alline","jeymessoncarias","jhonatan_francaa","jhonathanmonteiro13","jhonyprado","jhuniorferreira_","joanderson8456","joaokepler","joaomirandaz","joaopaulomedb","joaopeedro___","joaopspinheiro","joca_morais","johnattanasobrab","johnnberg","johnnypetteerson","johnromulo_","jonathannl2","jonathanpessoa27","jonnattas.delima","jonnyiuma","jose.hamiltondasilva.1","jose.samy.54","joseantoniosf84","joyce.thais","jpaulynho","jsparaiso","juandradec","jugallindo","julietemacedo","julio.l.amorim","julio_gk","junior.jive","junior26fernandes","junior_e.f.s","junioramancio53","juniorlvesskimboard","kaiosoutomaior","karenapullck","karinakellyk","karinesilviino","karinesilvino","karinesrabelo","karol_severo_","karollynyjessica","keilinha_ronielle","kellyd.monalisa","kellymedeiros.m","ketunymartins","kevinmuniz16","keziaafarias","khalil.pan","kikopontual","kkarolmonteiro","kkattianna","klebersonkl.lima","klebsonarts","kleubersou","kmilorenan","kskeila_sandy","kuro.miio","laara.medeiros","labibypinheiro","ladraosefudendo","lailson_santos_","laisfernanda_luna","lamartine_97","larifalcao_","larih.albuquerque","larijink","larissa.luciia_","larissa__liima","larissaevrs","lauralima_00","lauramendesjornalista","laymeson_do_pandeiro","leandro.laneves","leduararaujo","leeticia_amorim","leofarizeu","leokean","leomartorelli","leonanlewandowski","leonardo.ldiniz","leonartlima","leosalvador","lericardolima","leticia___nine","leticiajaninne","liimaheverton","liliansbastos","limajane40","lindembergvinicius","linedahora","livialocio","llaiscruuz","lory.salles","loryfreitas_","loveonthebrai.n","luaamcosta", _ "luanalima_96","luanferraz__","luanhenrique.edf","luanmarlonsantana","luanwallas1","lucaa.mendes","lucabeltrao","lucas.mick","lucas_damasceno_m","lucas_vitttorr","lucasgilbert","lucasleaotattoo","lucaslessapro","lucaslisboam","lucassalitos","lucianofernandesif","luiizzhsf","luizaaflima","luizfelipeslins","luizfelipess_","luizmpimenta","luizsantoscec","luna_mary654321","luuquinhasferreira","lyrowviva","maarlonfalcao","mafiosabe","maiconakiro","maliceteixeiraa","manamarcilia","manamoveispe","mands_siilva","mandynmakeup","marcelassbarros","marcelinoalvaro","marcellaapeixoto_","marcelo_arruda_","marcelopeixoto_s","marcialj29","marciarlima_","marciliosantosadv","marcioopaixao1980","marciopaixao20","marco_segundo","marcoslsantos12","marcossantiago4","mari.santiagofo","mari_andradih_","marial1ce","marialeticiacosta","marianamaralcampos","mariannealexandrino","mariarafaa","maricomber","mariiiguanaes","marilia.lf","mariliagabrielaamancio","marinaqueiroz1","marinho.francielly","marioabraga","marioeliaszinho","maritreez","marivaldo.silv","markos_bastos","marvininspaces","mateus.b.morais","mateus_damasceno","matheus_arts_777","matheus_da_rochaa","matiasnobletattoo","matiasribeiro.n","mayck_suillys","maygabiarruda","mayksrodrigues","mayllaness","mayy_andrade","medsonl","melicio_","mellosilverwind","messias313","metro.burguer","mfbmarcilio","micalandim","michaoliveira07","mikacavalcanti","milen_ah","milenaembirassu","milenamazonni_1","millycarneiro","milton_williamsx","mirarodrigues123","mirelibj","mirelli.freitas","mirreiz","mmila_souza","moabiamikaela","monicakely82","moniquearlete","moykerodrigues","mr_fael__","mrsaizen","mtsteuziin","mundodealice.m","murilo.smiranda","muriloh33","muriloneto.bat","naah.criis","naiaralima.nana","nairacarneiro1","nane.castro","nataly.coosta","natbarbachan","natinhasan","navas_gui","nayalegabriella","newmalima15","niltonsantiagopro","nilza.goncalves.334","noelyba","nutri_naianapassos","o_oguizinhor","oandersonrangel","oliveirajoao20","omariobros_","onnerb__","osmarjrpe","p3dro_borba","pablopdroza","paloma_barr0s","patriciocavalcantii","patrickrusso2","paula_ferreirs","paulao327","paularobertaconsultoria","paulasantanams","paulo.4.3","paulo.minze","paulorbeltrao","pbrunno","pedefoice","pedraogustavo","pedro__g0","pedroandrad3","pedrocouceirofilho","pedromendespersonal","peeh__silva","peetruz","peixoto_b","pereira_vitoriia","pereirowsk","phiappo","philipe2107","philiposo.ojuara","philliperocha7","pietra.michelle","plinioaustregesilo","pliniomeloo","pmoura.jpg","poliana.ps","pollianaaraujo019","pollysouza_13","preto.padrao","pri_moura","pridsouza","priscila_roberta19","psilvadidi","px.day","pydhio","queiroz.ti.unibratec","raafaaraamos","raafael_freitas","raayjl","rafaaelb7","rafael_bg","rafael_cabelinho_atleta","rafaelaborbamenezes","rafaelasouza1707","rafaellatargino","rafallima2104","rafapfernanda","rafy_nha1994","rai.__gercina","raianenascimeento","raimelorodrigues","ramacardoso","ramynemelo","raonybarbosa","raphaelario","rauana_carvalho","raul.braga","rauldiegodesousa","ray.ks","rayanagoncalves_","rayssafr","rbeatri","rcarollineoliveira","re_bekinha_santos","rebeccanobretattoo","rebekaolv","regi.jeronimo","rej_filmagens","renansantiago_","renata.valeria.9250","renata_lillia","renatajardimtattoo","renatakarllags","renatinhagabrielly","renatoaugusto07","rennan.mano","rfluizcosta","rherissongomes","rithhielly","robertavaljms","rodolfo.pacifico","rodolfoalexandreda","rodrigo0liveira__","rodrigo_silves","rodrigogarcia84","rodrigoh1997","rodrigomafraa","rogerio.rossiini","rogeriorossinipinheiro","ronin_posdigital","rosevieira794","rosi.silv4","rrafacavalcante","ruandanilooo","rubens_pinheiro_","runotattooer","sabrina_raissa","sabrinaaaa.lima","sammyle_","samuelclassicphysique","sanchez.39","sandnergaldino","sandrabvswp","sandromendesaraujo", _ "santnelle","santtos_monique","sarahflorenciio","sarathais9665","saulinhoaleixo","saulogodoy","selltoonn","senna.zn","sergiojrluiz","sergiojunior00_","service.tech01","sillasamazonas","silvana_yeshua","silvania_damasc","simonerecife.pe","simonesalesoficial","simoneses","smarivaldosilva","sousaronan","southamericamemes","souza_amanda14","srtahbetthy","stanislavcold","stanleydiias","stefan_costa2","studiorosianesouza","suelenarruda__","suhseedpersonal","sunonoticias","surteiatoa_","symonsantos13","t.i.a.g.o_silva","t_haisrafaela","ta_li_ssa","tahyaneamancio","tamiris_melo94","tarc_iis","tarciolimadj","tarcisiolima70","tata_goms","taticristinn_","taticristinna","tatyqueiroz23","tayenecarla","taynara_vittorino","tecnalex","thaiis.regiina","thainakerr","thaise.nandinha","thaiseduarda.s","thaiskananda","thalis.guilherme","thalysilva25","thalytaaaraujo","thamirismelo20","thamyresguerra","thatyotica","thays.almeida.79219","thezanfa","thiago.cmv","thiago.nigro","thiago_dienstmann","thiago_fgt","thiagoferreirassis","thiagogregorio","thiagoramon__","thiaguinhoraffa","thiiago01","thiiaguinhofernandes","thonyobara","tiago.m.tavares","tiago_santos890","tiagoopereeiraa","tinnabarreto","tm_angelini","tmelotavares","tyson_silva","vanny.goncalves","vantuirmuniz","verdao_hortfrut","vhfsouza","vicentezarga","victor.btorres","victorarrud4","victorfs2","victornik_","viniciusdercio","vinimoreirap","vitor_santos360","vitorbizzo","vitoriamarquees","vitoriavaleska","vrautom","wairanet","wan_pricila","wandasiqueira25","washington.jr","wendytoothfairy","willb_tattoo","willian_moraes_fotografia","willnickss","willwall_","winyesouza","wrllennia","xiiigente","yla_villar","yuriallan18" ]; Jos

Letraindusoir, I presume you are asking about why the TreeView appears on all tabs. I suggest reading the Tabs tutorial in the Wiki - you need to look after the hide/show of UDF-created controls yourself. M23

I am back with another bi-weekly (almost ) update, as usual I have been busy with life so progress is slow, but I have jumped another small yet-somewhat-significant hurdle, I have mostly figured out the basic skeleton of the syntax, to achieve this I had to spend 100% of my brain power for a couple of minutes almost every day for a two weeks Here is a sneak peak of the code: enum Operation { /* Addition, Substraction, Multiplcation, Division, Exponentiation */ OP_ADD, OP_SUB, OP_MUL, OP_DIV, OP_EXP, /* Concatenation */ OP_CAT, /* Equal to, Strictly equal to, Less than, Less than or equal to, Greater than, Greater than or equal to */ OP_EQU, OP_SEQU, OP_LT, OP_LTE, OP_GT, OP_GTE, /* Conditional */ OP_CON, }; struct Token { enum TokenType type; char *data; size_t data_len; void *info; }; struct TokenList { size_t length; struct TokenListNode *head; struct TokenListNode *tail; bool dirty; }; struct TokenListNode { struct Token *token; struct TokenListNode *prev; struct TokenListNode *next; }; struct Primitive { enum { PRI_NUMBER, PRI_STRING, PRI_BOOLEAN, // ... } type; union { //int number; //char *string; //bool boolean; }; }; struct Operand { enum { OPR_PRIMITIVE, //OPR_VARIABLE, //OPR_MACRO, } type; union { struct Primitive *value; //struct Variable *variable; //struct Macro *macro; }; }; struct Expression { enum Operation op; struct Operand operands[]; }; struct Declaration { enum {SCO_LOCAL, SCO_GLOBAL} scope; // ...Const, Static char *name; bool is_function; union { // Variable or constant struct Expression *initializer; // Function struct { struct Statement *block; size_t size; } code; }; }; struct Statement { enum StatementType { SMT_DECLARATION, SMT_EXPRESSION, } type; union { struct Declaration *declaration; struct Expression *expression; }; }; struct Unit { enum UnitType { UNT_COMMENT, UNT_DIRECTIVE, UNT_STATEMENT, } type; union { struct Token *token; struct Statement *statement; }; }; The above code is basically the struct declarations that I extracted from my WIP code, these structures reference each other to form a single "code unit" which roughly corresponds to a single line of code in the AutoIt syntax. I have tried to arrange the declarations in the ascending order, where the top-most structure roughly represents the most basic element of the syntax (the token in this case) which is contained in a more informative and complex structure, all the way to the bottom where the "Unit" structure has a fully formed meaning. This should be enough for me to start writing code to construct the syntax tree, but there are some other things that I would like to work on first. Right now I am looking into incorporating debug data into the final binary, so that we can have a nice debugger to debug our scripts . It is not necessary that I look into this right now, but it will come in handy if I study and understand the basic concepts of how the debugger maps the final instructions to strings in the source code, so that I can make modifications to the syntax tree's design right now, as opposed to in the future to prevent inconvenience of re-writing of related code. Basically leaving gaps in the tree which I can fill later when actually implementing the debugging functionality. A good example to study in my opinion is the format used by C debuggers (gdb and co.), and I found out that the format is called DWARF (Name FAQ), I tried to read their technical specification but it is too thick for me right now... but luckily I found an article called "Introduction to the DWARF debugging format" written by the Chairman of the standardization committee, lucky me . So I am reading that right now. Hopefully I will have another update for you in 2 weeks, see you until then!

A regex way $sInput = "1234567890.1234567" $sOutput = StringRegExpReplace($sInput, '\G(\d+?)(?=(\d{3})+(?:\D|$))', '$1,') MsgBox(0, "Result before and after", $sInput & @crlf & $sOutput)