ashly

@RTFC Thank u very much! My problem is solved after seeing the article u mentioned.

@AutoBert thanks for your reply. yes, i had tried with values but it is still the same.

i'm trying to use _ScreenCapture_Capture($sFileName) to cature full screen and save as a jpg file, but it always only capture the left-top about 3/4 area. but the print screen keyboard woks fine. and if i changed the display resolution from 150% to 100%, the jpg file is OK as well. so the issue only occurred when resolution is 150%. is there anybody know why or how to change resolution percentage by scripts? Thanks.

I just changed the path to desktop then it works! Don't know why i cannot save it to my USB. Anyway, thank you so much, @l3ill

@l3ill Thanks for you reply. The path is just for this post. I'm actually using another path to save it in my USB stick.

I would like to create a new excel workbook and using below scripts. But it fails with @error=5 and @extended=-2147352567 I can't find out which part is wrong. Please help me~~~ #include <Excel.au3> Local $oResultExcel = _Excel_Open(False) Local $oResultBook = _Excel_BookNew($oResultExcel, 1) _Excel_BookSaveAs($oResultBook, "C:\test.xlsx", $xlWorkbookDefault) If @error Then Exit MsgBox(0, "Error!", "Error saving workbook to '" & $oResultBook & "'." & @CRLF & "@error = " & @error & ", @extended = " & @extended)

Thank u sooooooo much!! It works with v.3.3.14.2 i'm running.

I had googled such topic and tried all they said but still cannot find a helpful answer. Below script is what i use, and it always stop with error "The requested action with this object has failed." when the cell has no comment. $sComment = $oTM.Worksheets($sWorkSheetName).Range($sColLetter & $j).Comment.Text If $sComment = "" Then ...... EndIf If there's someone can help me that would be great.

U'r right! I try to set the $bVisible parameter to True then the problem is solved. Thank you so much!

Hi, i'm trying to read a range of value of my excel files and it works with _Excel_RangeRead(). After that, there'are _Excel_BookClose() and _Excel_Close() to close the file. However, now the file is empty when i double-click to open it, but i still can read the value by my AutoIt program. Is it possible to restore my excel files? And why would it be like this?

I just double click to open other excel then the script crashed.

it seems like only happen when reading the value from cells if i only open an excel and do nothing then i could open any other files i want then i found other guys can run my script and open other files successfully why??? is there any setting i need to modify for my computer? my simple scripts: #include <Excel.au3> $oExcel_DM = _ExcelBookOpen(@ScriptDir &amp; "Result.xls", 0) $iCol_DM = $oExcel_DM.Cells.SpecialCells($xlCellTypeLastCell).Column $iRow_DM = $oExcel_DM.Cells.SpecialCells($xlCellTypeLastCell).Row For $i = 1 To $iCol_DM For $j = 1 To $iRow_DM ;MsgBox(0, "", $i &amp; "," &amp; $j) _ExcelReadCell($oExcel_DM, $j, $i) Next Next _ExcelBookClose($oExcel_DM, 0) the error message is like below: AutoIt3IncludeExcel.au3 (694) : ==> The requested action with this object has failed.: Return $oExcel.Activesheet.Cells($sRangeOrRow, $iColumn).Value Return $oExcel.Activesheet.Cells($sRangeOrRow, $iColumn)^ ERROR open defferent excel will cause different error AutoIt3IncludeExcel.au3 (194) : ==> Error in expressi&#111;n.: For $i = 1 To .ActiveWorkbook.Sheets.Count For $i = 1 To .ActiveWorkbook^ ERROR

i have an autoit script to access A.xls like below _ExcelBookOpen("A.xls") no matter invisibly or visibly with the flag, if i open other files (B.xls, C.xls...) then the script will crash is it a known issue or i have done something wrong?

i would like to ask if there's any way to compare 2 1D arrays quickly rather than using for-next loop to compare them one by one? thanks.

thanks a lot for your reply!! i can now get the format for filter by the way, i got null from reading a cell that is not the first one of the merged cell do you know how to share the same value for the merged cells or to know which cells are merged together so i can get value of the first one?

i would like to compare 2 excel files ( A and B ) and i want to ignore the items with strikethrough in A i try to google the relative subject but i cannot find such function to deal with it only the way to set a cell with strikethrough is here anyone can help me to get the answer i would be very appreciated