Leaderboard

Hello. Proably you could also add a hotkey and detect topic name etc to organize all better. Maybe You can get interested in this. Probably I'll develop a firefox version too. Saludos

Seems you need to re-install/repair MS Office

This script: ;https://autoit.de/index.php?thread/86082-treeview-root-verbergen/&postID=691139#post691139 #include <File.au3> #include <WindowsConstants.au3> Global $sPath = @ScriptDir Global $hGui = GUICreate('TreeView-Example', 400, 600) Global $idTreeView = GUICtrlCreateTreeView(10, 10, 380, 580, Default, $WS_EX_CLIENTEDGE) GUISetState() _CreatePath($sPath, $idTreeView) Do Until GUIGetMsg() = -3 Func _CreatePath($sPath, $idParent) Local $aFolder, $aFiles, $idItem If StringRight($sPath, 1) <> '\' Then $sPath &= '\' $aFolder = _FileListToArray($sPath, '*', $FLTA_FOLDERS) If Not @error Then For $i = 1 To $aFolder[0] $idItem = GUICtrlCreateTreeViewItem($aFolder[$i], $idParent) _CreatePath($sPath & $aFolder[$i], $idItem) Next EndIf $aFiles = _FileListToArray($sPath, '*', $FLTA_FILES) If @error Then Return For $i = 1 To $aFiles[0] $idItem = GUICtrlCreateTreeViewItem($aFiles[$i], $idParent) Next EndFunc does same as yours with native GUICtrlCreateTreeViewItem and _FileListToArray.

The value of extended (decimal) stands for 0x80040154 (hex) and means: COM Exception: Class not registered - HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG) Do you run a full version of Excel (not a trial version or an upgrade after you have installed a trial version)? Which version of Excel do you run? Did you install or update your Office software lately?

also.... https://www.autoitscript.com/forum/topic/177201-_iegetobjbyclassname/

...should be the question of 90% of all the Excel-relating requests in this forum. *OT-mode ON* The only (for me) meaningful use of AutoIt with Excel is to extract or to put in/out Data from/to extern (3rd) Programs. Or control processes of other Programs from Excel/Word/any other VBA controllable software. I cannot understand why people use a programming language like AutoIt (with whom they have no experience, otherwise they would not ask the simplest tasks here in the forum) instead of using the also "BASIC-like" build in programming language. Don´t they know what the "B "in VBA means?! I think it would be a good idea to show how easy most of the here posted "Excel-related problems" could be solved with some lines of VBA-code. Some links to a friendly VBA forum anyone? Could be the start of a cooperation of two forums with mutual participation. (BIG smilie here ^^) I bet that even experienced VBA-programmers would like AutoIt because of its wonderful possibilities! *OT-mode OFF*

Just use something like: Local $oIE = _IECreate("http://www.sitename.com") Sleep(5000) Local $oInputs = _IETagNameGetCollection($oIE, "input") If IsObj($oInputs) Then For $oInput In $oInputs If $oInput.ClassName = "ClassName" Then _IEAction($oInput, "click") ExitLoop EndIf Next EndIf

also take a look at the _ArrayToString() function...

Here you have something to study and play with: #include<Array.au3> $str = "18,03,48,23" $aStr = StringSplit($str,",",2) _ArraySort($aStr) for $x = 0 to UBound($aStr)-1 MsgBox(0,"value " & $x ,$aStr[$x]) Next Jos

@jtaft Why don't you read all the used range of your data, and work with it ( faster, easier ) ?

Hello. My brother and I wrote this small Google Chrome extension that allow load(No Run Directly. you must press F5) the code directly in SciTE. By default Scritps are saved in Desktop when you run it. How to Install: In host Folder Run install_host.bat (try to keep an static folder) If you move the folder after you run install_host.bat You must install again. Load The Extension (autoitextension Folder) as Developer Mode In Google Chrome Settings. You can edit AutoitCodeRunner.au3 to make it work as your need. How it works. Basically It Injects a "Run" Button in every AutoIt code tag Like This: Check Source for more details. AutoItCodeRunner.zip Regards

Ok, so you're thinking out of the box, now the only thing left to do is to escape the box that makes you make assumptions. Unrar.dll is a "free" library.