Jump to content

vkrisz81

Active Members
  • Posts

    179
  • Joined

  • Last visited

Everything posted by vkrisz81

  1. Do you use it? I saw some tutorial but there he used java to communicate to it.. Can i use it as ie.au3 udf? Yesterday ibtested ie.au3 on win 10, works enough well... only win11 generates problem to me .. :S I check the wiki, but i thought closer personal helps in this theme for a better performance Thank you
  2. Dear team! I worked a lot with ie and i loved it. After many years i must again work with webpages but sadly ie does not work properly in win11.. i thought i try edge or chrome but i would need to find a complete userguide for it. Anyone can help me to explain how it works now?i wish to use similar methods than i could with ie.. fill out forms, read webpage, make logins, etc.. Would you tell me how you do it nowadays? I dont want to use java, other external languages, i wish to work as i could with ie.. only with an udf if its possible. Very thank you for informing me!
  3. i can see now, after breaking protection, cell format is a special, star sign marked date format .. but i dont know how to fix this bug.. i can see, the data wich are compared to this field are "8.8.22" and "23.8.22" which are date format by excel. if i type by program 22.8.22 does not accept, but if i type an enter on field it ok. ..
  4. hello , i have another issue on handling cells. i have a password protected file to cover and def function and calculator cells, its ok. i have a cell where i must type a date. IF i place it manually, "2022.09.13" function says ok if i type it by autoit as sheets().cells()="2022.09.13" it says error i read the value when its ok, says value is "20220913000000". once i met with this when i used vba codes.. BUT if i write to cell this "20220913000000" excel says error, do i have to break password protection to find out which cellformatting is applied? or how can i solve it? thank you
  5. thank you Luke, this really works!
  6. hello dears! i have a program which manipulates excel.. data and formatting. i have faceing with a hugr problem: how can i force document when i want to print, must be only 1 page ? if i use $workbook.sheets(1).pagesetup.Orientation = 2 ;landscape works well, document orientation changes to requested. but when i use $workbook.sheets(1).pagesetup.FitToPagesWide=1 $workbook.sheets(1).pagesetup.FitToPagesTall=1 does not work Please, how can i modify document to store new setup for printing parameter? is there another parameter which i should use? i thought it may be unnecessarry because here i dont want to fit, content is bigger than printarea. i must zoom out to store everything in one page.. Thank you for your support!
  7. of course, i dont blame the creator, i just am angry because i must to start to a new direction and the first step is blocked by this type errors.. this is not against creators or similar, this is against the system.. new new new systems but are not working.. as well win xp existed.. how many years? was very stable. win 7 existed how many years? was stable now win10.. win11.. and bug bug bug :S and i am forced to follow this because of .. throw it.. thanks i try to fix this
  8. i would like to ask some help: i downloaded the chm file from your github map, to see how its working, but i can see only the keywords on left side, nothing deeper content on right side.. how its possible? that is the greatest way when you planned to know something new where the first step is an invalid.. now lets learn.. this is why i dont want to let away ie.. a once for all working method instead of these forced bugged ...
  9. l(IsObj($o_filltable.sheets(1).cells($row+1,$oszlop+$isheetnum))) $o_filltable.sheets(1).cells($row+1,$oszlop+$isheetnum).value=Number($a_sheetdata[$pos][3]) i check it if its an object, program says 1, which means yes it is. next line:$o_filltable.sheets(1).cells($row+1,$oszlop+$isheetnum).value=Number($a_sheetdata[$pos][3]) $o_filltable.sheets(1).cells($row+1,$oszlop+$isheetnum)^ ERROR variable must be an object.. is it a bug?
  10. ok, i set it on $o_excel object, screenupdating=false. still cells are changing during program runs.. i mean WHY? i ran program twice. once i focused window, once not. not focused ran perfectly, when i focused filltable, program halted.
  11. instead of whining thats correct :d i typed what com errors come but, newer error comes.. program_4_filler_002_002.au3 (143) : ==> COM Error intercepted ! err.number is: 0x80020008 err.windescription: wrong variable type err.description is: err.source is: err.helpfile is: err.helpcontext is: err.lastdllerror is: 0 err.scriptline is: 143 err.retcode is: 0x00000000 "\program_4_filler_002_002.au3" (143) : ==> Variable must be of type "Object".: $o_filltable.sheets(1).cells($row+1,$oszlop+$isheetnum).value=Number($a_sheetdata[$pos][3]) $o_filltable.sheets(1)^ ERROR which is dont problem for previous cell or next cell.. still excel still excel udf thanks
  12. so i use excel udf, and after i made a diffrernt method of working with arrays, program generates same problem.. on other part of program but on same place: accessing a worksheet().cells still same error. so it seems i cant use excel udf, because if i outplay somewhere, udf generates another place.. while i use excel udf.. i dont know still how other wy can i solve my tasks, but it seems disabled to using excel udf. i know only this. and this is unacceptable, something is wrong, if i solve it, program generates same problem on place where was correct... it seems does no matter where i try to handle error, somewhere never will work. sad but its tested around 200times.. the whole process is: i have a sourceexcel, i read it to an array by using excel range read i have another workfile excel, where i must insert to, seeking by the second column datalist.. sorted.. filtered.. etc. so i applied a simple arraysearch to find the requested element in the first source table and put the value into the workfile, but every time i try to access workfile cell it generates random place object error.. cell is there, program reached 30000000times before, once it thinks it wont. if i make an error handling, it drop this error on other place in program.. the result is, i cant use excel udf. unstable.. thanks new result: the row which generates error: "167: $o_filltable.screenupdating=True" ;after filling switch back screenupdate. the errormessage: program_4_filler_002_002.au3 (167) : ==> COM Error intercepted ! err.number is: 0x80020006 err.windescription: unknown name err.description is: err.source is: err.helpfile is: err.helpcontext is: err.lastdllerror is: 0 err.scriptline is: 167 err.retcode is: 0x00000000
  13. problem solved by making complete different method.
  14. l("$o_filltable.sheets(1).cells($row,2).value="&$o_filltable.sheets(1).cells($row,2).value) so when i print its value this link works.. 18:54:32 $o_filltable.sheets(1).cells($row,2).value=RPLO400068 "\program_4_filler_002_001.au3" (101) : ==> The requested action with this object has failed.: $s4seek=$o_filltable.sheets(1).cells($row,2).value $s4seek=$o_filltable^ ERROR in next line when i try to assign same cell value to a variable, it gives error. nonsense...
  15. \program_4_filler_002_001.au3" (95) : ==> The requested action with this object has failed.: l("$o_filltable.sheets(1).cells($row,2).value="&$o_filltable.sheets(1).cells($row,2).value) l("$o_filltable.sheets(1).cells($row,2).value="&$o_filltable.sheets(1)^ ERROR here you can see it can not refer to cell of the sheet. but the cell is there.. clearly.
  16. sry i cant post here because it contains private datas for a nonstandard company :S the event is : program_4_filler_002_001.au3" (95) : ==> The requested action with this object has failed.: $s4seek=$o_filltable.sheets(1).cells($row,2).value $s4seek=$o_filltable.sheets(1)^ ERROR and the problem is, i dont know what is the exact problem for excel udf with this cell, or, if i put an if @error, why program ignors it and exit? $o_filltable.sheets(1).cells($row,$oszlop+$isheetnum)=$a_sheetdata[$pos][3] if @error Then l("error at "&@ScriptLineNumber) ;~ $o_filltable.screenupdating=True ;~ exit so this part is not executed, however there is on error part.. so i dont know what is the problem with given "object", and why does not run the error handle part od the script if an error occurs.. thanks you S: and the mainly problem is, sometimes it works sometimes not. without any change on source or.. the program.
  17. yes of course this is the easiest way to do but, really, what needed if a script sometimes works, sometimes not on the same source data..? do you think is there needed any extra description?:D i mean, if there is a method how a statement works, it should always work or always not work on same data. but if without changing source it is randomly bugged, whispers to me something similar is the fail not in my script what is not changing. but thanks your hard work in thinking about possible errors helped lot ^^
  18. i tried disable screen refresh, independ... trash
  19. ok i give up.. this is unhandable.. sometimes 4 row passes, sometimes 44.. i put sleep for dealy, worse.. its unacceptable..
  20. hello i have a read/write program, but randomly it goes to fail: ==> The requested action with this object has failed.: $s4seek=$o_filltable.sheets(1).cells($row,2).value $s4seek=$o_filltable.sheets(1)^ ERROR the problem occurs randomly, various places.. how can i fix it? if a row is selected and sheet saved, program breaks.. sometimes, here and later on other cell, it breaks.. what is the good way to fix it? its unstable..
  21. thanks you, thats ok and clear to me now.
  22. the problem was this is a 2dimensional array not one.. :S thanks you
  23. hello, i have newer bug i make a sheet list by excel_sheetlist i can list it by arraydisplay but if i want walk through by for i cant it says out of range.. i mean HOW???????????????????????? 14 sheets available i cant refer to $asheets[4] forexample WHY????????????? thanksyou
  24. hello! once it works once not and i cant find out what is the problem.. a simple sample from helper, $list=_excel_booklist() and if i open manually the file it does not find when i open a file from program and i open manually my fiile, it lists otherway says empty.. where is the bug? thank you
×
×
  • Create New...