Search the Community
Showing results for tags 'excel.au3'.
Found 8 results
-
I'm having some issues with my script that's not grabbing the id from the cell and appending it to the url test that I have in my script. Here is my script: #Include "wd_core.au3" #Include "wd_helper.au3" #Include "wd_core.au3" #Include "File.au3" #Include "Array.au3" #Include "Excel.au3" #Include "INet.au3" Local $sDesiredCapabilities, $sSession _WD_Startup() $Ssession = _WD_CreateSession($sDesiredCapabilities) _WD_Navigate($sSession, "https://127.0.0.1/test.html?id=1");session is created -
An example of updating an excel file with a join between excel range and access tables. #include <Excel.au3> #include <Array.au3> #include <MsgBoxConstants.au3> ;#include <WinAPIFiles.au3> ;Permitir unha única instancia da aplicación #include <Misc.au3> ;_Singleton("ADO_Update_Excel_From_Access", 0) If _Singleton("ADO_Update_Excel_From_Access", 1) = 0 Then MsgBox($MB_SYSTEMMODAL, "Warning", "An occurrence of test is already running") Exit EndIf Opt("MustDeclareVars", 1) Opt(
-
Dear all, first of all hi. I`m in trouble, again 😕 I can`t find right solution, tried all possible combinations generated by my mind and nothing. I need to copy range of values depending by values from two different cells in excel sheet. I put an example in attachment. I have two values which is never changed (is changed only TEXT). I need to copy all the rows from VALUE 1 to VALUE 2 in new Sheets (Output 1, Output 2, ... , Output X). It is possible to do this using Autoit? 🤔 Also in attachment you can find last example which I have tried and it`s s -
Hi, I have a set of excel docs 1& 2 1) In Excel 1 i have a fixed column called dimensionId that contains list of dimensionid's with in between empty cells. Here, For each dimesionId, i need to check corresponding columns of L,M,N ,O(senior, mid, junior, student) & check If they contain letter Y (Open excel 2) and if empty ignore,check next. I need to loop through the entire column of dimensionId one by one, please help me proceed with the logic. 2) If letter Y exists, open excel 2 and check if same dimesionId exists in column A. New to autoit excel automa
-
Hi, is it possible to break link in active/open $oWorkbook0 with excel.udf function ? If some could link some example... Data-Edit Links-Break Link
-
First post, be gentle I am working on a script that will eventually run via a batch file with Task Scheduler. The purpose of the script is to query SQL Server and save the results as .xlsx files. However, when I run the script either from the editor or compiled file, the excel windows open and I have to close them for the script to continue. I did not have this issue initially, the excel windows would open and then close on their own. Below is code from one section of the script where I am creating my spreadsheets. This code creates a single spreadsheet with a list of invoices -
Hello, I am receiving the following error: What is strange (to me), is that this error only occurs during a loop. If I manually iterate through each count, it works fine, but as soon as I put it back in the loop, it shows this error. I would appreciate any feedback you can give. I will post code below. Local $sFilePathForILPs = @ScriptDir & "\ILPs" Local $aArrayOfILP_Files = _GetListOfILPsInDirectoryToBatch($sFilePathForILPs) For $iCC = 1 To UBound($aArrayOfILP_Files) - 1 Local $oILPWorkbook = _Excel_BookOpen($oExcel, $sFilePathForILPs & "\" &
-
I am using the version of Excel.au3 that came with auto-it but it says undefined function when I try to run it. Here is the code. Thanks Local $oExcel = _ExcelBookNew() ===================SHOWS undefinded function _ExcelWriteSheetFromArray($oExcel, $Model1, 1, 1, 0, 0) ===================SHOWS undefinded function
