Juvigy

Excel 2010 template is .xltx
You can saveas files as .XLSX :

$oExcel.ActiveWorkbook.SaveAs ( "c:\filename.xlsx",51,"","",False,False)

Check out this example. It is for the outlook tray icon.


#Include <GuiToolBar.au3> #NoTrayIcon Global $hSysTray_Handle, $iSystray_ButtonNumber Global $sToolTipTitle = "Microsoft Office Outlook" ; <<<<<<<<<<<<<<<< Enter some tooltip text for the icon you want here ;~ WinActivate('[Class:Shell_TrayWnd]') ; if taskbar is Autohide $iSystray_ButtonNumber = Get_Systray_Index($sToolTipTitle) If $iSystray_ButtonNumber = -1 Then MsgBox(16, "Error", "Icon not found in system tray") Exit Else Sleep(500) _GUICtrlToolbar_ClickButton($hSysTray_Handle, $iSystray_ButtonNumber, "right") EndIf Exit Func Get_Systray_Index($sToolTipTitle) ; Find systray handle $hSysTray_Handle = ControlGetHandle('[Class:Shell_TrayWnd]', '', '[Class:ToolbarWindow32;Instance:1]') If @error Then MsgBox(16, "Error", "System tray not found") Exit EndIf ; Get systray item count Local $iSystray_ButCount = _GUICtrlToolbar_ButtonCount($hSysTray_Handle) If $iSystray_ButCount = 0 Then MsgBox(16, "Error", "No items found in system tray") Exit EndIf ; Look for wanted tooltip For $iSystray_ButtonNumber = 0 To $iSystray_ButCount If StringInStr(_GUICtrlToolbar_GetButtonText($hSysTray_Handle, $iSystray_ButtonNumber), $sToolTipTitle) <> 0 Then MsgBox(0,$iSystray_ButCount,$iSystray_ButtonNumber) Return $iSystray_ButtonNumber ; Found EndIf Next Return -1 ; Not found EndFunc

Or you can use :



oExcel = ObjCreate("Excel.Application") $oExcel.Visible = 1 $oExcel.WorkBooks.Open ("full path filename") $oExcel.Sheets ("sheet name" ).Select

Personal satisfaction and harder to read script.

Personal satisfaction and harder to read script.

$oExcel.Application.ActiveWindow.ScrollRow = 1

You can create ODBC or Data connections without anything ,then you just need to open it in SQL Dev.

I think you will need to have a look at the :
StringRegExp
StringRegExpReplace
The IE functions would work too, but it will be different way , and most likely more complicated.

Now it works.
C:|Operating System Volume|Unkown|Protected|Unlocked|False|False|Fully Encrypted|AES_256|100|Free Space Not Wiped||{Array} {CF607D86-743D-4E29-8FF2-A49D0D7AB820}|Numerical password {B1AA7EF7-AC39-4D21-A278-B12EA6AA5F2B}|Trusted Platform Module (TPM) !> GetConversionStatus 0x00000000 !> GetEncryptionMethod 0x00000000 !> GetKeyProtectors 0x00000000 !> GetLockStatus 0x00000000 !> GetProtectionStatus 0x00000000 !> IsAutoUnlockEnabled 0x80310019 !> IsAutoUnlockKeyStored 0x00000000  

Try this:
global $a,$b,$c $strComputer = @ComputerName $objWMIService = ObjGet("winmgmts:{impersonationLevel=impersonate}!\\" & $strComputer & "\root\CIMV2\Security\MicrosoftVolumeEncryption") $objWMIQuery = $objWMIService.ExecQuery("SELECT * FROM Win32_EncryptableVolume WHERE DriveLetter='C:'", "WQL", 0) For $objDrive In $objWMIQuery $res = $objDrive.GetConversionStatus($a,$b,$c) ConsoleWrite("> " & $res & @CRLF) ConsoleWrite("> " & $a & @CRLF) ConsoleWrite("> " & $b & @CRLF) ConsoleWrite("> " & $c & @CRLF) Next Exit And here is the documentation:
uint32 GetConversionStatus( [out] uint32 ConversionStatus, [out] uint32 EncryptionPercentage, [out] uint32 EncryptionFlags, [out] uint32 WipingStatus, [out] uint32 WipingPercentage, [in] uint32 PrecisionFactor );  

Yes, it can be done in many ways. Instead of google sheets and so on , you can just get the balance via the IE functions and then write it in the excel file with the excel functions.

You need something like this t put before your click.
_ExecuteInBackground _IEAction($oDiv,"click") Func _ExecuteInBackground()     Local $sCommand = _             'Local ' & _             '$Dummy1 = WinWaitActive("Choose File to Upload", "", 20), ' & _             '$Dummy2 = Sleep(1000), ' & _             '$Dummy3 = ControlSetText("Choose File to Upload", "", "Edit1", "C:\Path\To\File.doc;C:\Path\To\File1.doc"), ' & _             '$Dummy4 = ControlClick("Choose File to Upload", "", "Button1") ' & _             ''     $sCommand = '"' & StringReplace($sCommand, '"', '""') & '"'     ConsoleWrite($sCommand & @CRLF)     Run(@AutoItExe & ' /AutoIt3ExecuteLine ' & $sCommand) EndFunc   ;==>_ExecuteInBackground

Ahmed, the CELL is an object. You cant display an object in the msgbox. You have to display the object properties - for example $cell.Value or $cell.Text

$oExcel.Run("PGProFund",$string)

You can also do it in the registry with the registry functions. Also very easy.

Put the EXE for example calc.exe in a Citrix desktop. You can know who is logged in in the citrix and using the app. And you can have AD logins to the citrix desktop so only registered and allowed users can use the app. Users will not be able to change anything in the citrix environment.

The control that you are clicking is stealing the focus. Some controls do it because they perform some actions at the background. It is normal.

You can return the focus to the desired window with Autoit right after the control click.
You can also try making the window minimized,invisible or the control enabled/disabled and so on.

You don't have to try only, you need to think also.
For $i = 0 To ($iNumFrames - 1)     $oFrame = _IEFrameGetCollection($oIE, $i)     $sTxt &= _IEPropertyGet($oFrame, "innertext") & @CRLF Next Inside the above code you need to put your code from the first post. So that way for each frame found you need to try to get the button you want to click on as you dont know in which frame it is located!

Can you post real data examples? For example is it Size1|Duhovni and Size1|David or Size1|FirstDuhovni

Be careful because this will turn anything to false - for example if var is number 5 or text "abc". In C there is a Boolean variable type, here it is a little bit different.

Use excel and record a macro of what you want to do. Then use Excel UDF and convert the macro to Autoit. It is very easy.

Thank you Melba23. I tried to search but couldn't find it.
Earthshine,
Who said that $MS doesn't have a sense of humor?
 

Try :
$oIE.document.parentwindow.execScript("imSubmitAction('action.standardsearch.detailed');")  

Just get the link to the file - it should look like the bellow:
 
$path = "https://sharepoint.com/teams/folder/file%20name.xlsx" $oExcel = ObjGet("", "Excel.Application") $oExcel.Application.WorkBooks.Open($path) Works great.