Juvigy

Managed to implement this with: $oExcel.Application.ActiveWorkbook.Activesheet.Range("A252:A255").FormulaR1C1 = '=INDIRECT("O"&ROW())/INDIRECT("AE"&ROW())/INDIRECT("AF"&ROW())'

Hi Guys, I have a strange issue - maybe i miss something. This works in excel VBA: Range("A252:A255").Value = "test" This doesnt work from AutoIt : $oExcel.Application.ActiveWorkbook.Activesheet.Range("A252:A255").Value = "test" What am i doing wrong? i dont get any errors - i do have an error handler to check for those, nothing pops up. Turned out i had completely different issue - the above works from Autoit, it didnt work few times due to a bug - after restart of excel it works. What i try to do is implement something like: $oExcel.Application.ActiveWorkbook.Activesheet.Range("A252:A255").Formula = '=O&row()/AE&row()/AF&row()' Which produces in excel "=@O&ROW()/@AE&ROW()/@AF&ROW()" which doesn't evaluate and gives an excel formula error.

Are you sure $sheet_names[$i][0] is a valid sheet name? Put a check before that line.

And where exactly do you get the error?

Personal satisfaction and harder to read script.

You can put the revised collection one by one in a Array. It will become an array of single objects. $oColorList = GetObjectList("color") For $oColor In $oColorList     If StringInStr($oColor.GetAttribute("aria-disabled"), "true") <= 0 Then         _ArrayAdd($oColorListNew, $oColor)     EndIf Next

It depends how you started IE or attached to it, but you can start a separate instance of IE, then hide only that instance and leave whatever the user has intact.

What do you mean? You can navigate the same way each time. Just change the 'address' parameter

Hi Caria, When you manually click it - is it behaving the same? One way to do this is to hid the entire IE as an application before clicking and show the first instance only after you have attached to the new window that will remain hidden.

First use _IEFrameGetCollection to get the frame and them _IELinkGetCollection to get the link and click on it with _IEAction

#requireadmin in the beginning of your script should solve your problem.

It stops my outlook macros that call autoit scripts.

@Water, Good day to you. Could you please advise or point me at the right direction. I have a problem with outlook on my company PCs. A policy or something (i couldnt figure out what) is changing the macro security settings like the bellow: This totally brakes my scripts and efforts. I am using a regfix to update it to: But i dont know when and what is changing my settings and i need to close and open outlook after the regfix for the changes to take effect. Do you have any ideas or suggestions i can do to fix this?

For example with FileRead() ...

Put it in a windows service...