6 posts in this topic
i have an error:
==> The requested action with this object has failed.: $iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count $iRowCount = .Range(^ ERROR
My code is:
$oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell) Sleep(1000) $iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count Sleep(1000) _Excel_RangeWrite($oWorkbook_1, $oWorkbook_1.ActiveSheet,$aFileList[$i] , "AB3:AB"&$iRowCount) I have added some sleep because the application was crashing more often before, so i thought to slow down the code execution.
But i didn't solve the issue.
Has anyone an idea of what the problem might be?
Thanks in advance.
Extensive library to control and manipulate Microsoft Excel charts.
Written by GreenCan and water.
Theads: General Help & Support - Example Scripts
BTW: If you like this UDF please click the "I like this" button. This tells me where to next put my development effort
KNOWN BUGS (last changed: 2017-07-21)
None. The COM error handling related bugs have been fixed.
i have a problem with the deletion of an empty row in Excel.
If $vRow_2 = "" Then _Excel_RangeDelete($oWorkbook_1.ActiveSheet,"2", $xlShiftUp,1) EndIf I want to delete the second row. $vRow_2 is an empty cell, "A2".
After running the code, the second row is not deleted.
I have tried also:
If $vRow_2 = Null Then _Excel_RangeDelete($oWorkbook_1.ActiveSheet,"2", $xlShiftUp,1) EndIf But it doesn't work.
Thanks in advance.
My esteemed Autoits I need your help once again.
I'm trying to figure out how to create a loop that gets 1 value from an array and repeats until each value from the array has been used. I have never used arrays before and I know once I learn more things should get easier for me.
Here is what Im trying to do:
-Have an array of values that determine what application i log into. ex: app1, app2, app3, app4 etc.
-Have a loop that repeats a process sequentially using each value in the array to finish the process for each app1, app2, app 3 and so forth. I have 30 apps that I need to update on a regular basis and getting this sorted out is what I perceive to be the best way to do it.
Here is my feeble attempt that obviously fails:
local $array = ["10", "11", "12",etc etc]
;;Local $site = InputBox("ERx Site","What site do you want to login as?","","")
Local $userid = InputBox("ERx Login", "What is your username?", "", "")
Local $Passwd = InputBox("Security Check", "Enter your UAT password.", "", "*")
for $1 = 1 to 30(I need to do the same steps in 30 different apps)
Send (Sequential ARRAY VALUE HERE)
your help is greatly appreciated.
Thanks for your time
I'm trying to insert the following formula in cell A2 using my script:
=if(A1=""; "YES"; "NO")
To my understanding, the line of code should be similar to this:
_Excel_RangeWrite($MasterFile, Default, "=if(A1=""; "YES"; "NO")", "A2")
However, it does not work, probably due to the multiple quotation marks that confuse the script :C
How do I avoid this problem?