Sorry if this is a repost, but having some trouble searching for the answer and pretty tired right now.
I'm just wondering how to make a border around a range of cells in Excel. I want the regular lines created by selecting "All Borders" option around F2:G3
I saw this code:
With $oExcel.ActiveSheet.range("F2:G3") .Select .Borders($xlEdgeBottom).LineStyle = $xlContinuous .Borders($xlEdgeBottom).Weight = $xlThick .Borders($xlEdgeBottom).ColorIndex = $xlAutomatic EndWith but I get errors of these variables not existing. It seems these no longer exist in the "#include <Excel.au3>"
Is there another include file I need?
I got this to work for highlighting cells, wondering if there is a option similar to this for all borders?
$oExcel.ActiveSheet.Range("F2:G3").Interior.ColorIndex = 6 Thanks
I am working on a script that will turn all file names in a directory into an array, and then writes this Array to an Excel file.
This in itself is working, but the RangeWrite function always puts the Array count in the first cell.
How can i make sure this does not happen? I can of course just filter it out in Excel, but i am trying to keep all logic of filtering text in my script.
This is what my script looks like:
Local $Yesterday = _DateAdd('d', -1, _NowCalcDate())
Local $cDate = StringReplace($Yesterday, "/", "-")
Local $aFileList = _FileListToArray(@WorkingDir & "/" & $cDate, "*")
Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookNew($oExcel)
_Excel_RangeWrite($oWorkbook, $oWorkbook.Activesheet, $aFileList)
Is there a way wherein I can access the data from an array coming from an Excel file then have it assigned on to a variable?
Below is a snippet of my current code. For now, it just reads and outputs the data from the excel file and have it displayed via an array.
#include <Array.au3> #include <Excel.au3> #include <MsgBoxConstants.au3> Local $oExcel = _Excel_Open(False) If @error Then Exit MsgBox(0, "Error", "Error creating application object." & @CRLF & "Error: " & @error & " Extends: " & @extended) ; Open Excel Woorkbook and return object Local $sWorkbook = @ScriptDir & "\Excel Files\Test Data.xlsx" Local $oWorkbook = _Excel_BookOpen($oExcel, $sWorkbook, False, True) If @error Then MsgBox(0, "Error", "Error opening workbook'" & $sWorkbook & ".'" & @CRLF & "Error: " & @error & "Extends: " & @extended) _Excel_Close($oExcel) Exit EndIf Local $aResult = _Excel_RangeRead($oWorkbook) ; Error Trapping If @error Then MsgBox(0, "Error", "Error reading data from '" & $sWorkbook & ".'" & @CRLF & "Error: " & @error & " Extends: " & @extended) _Excel_Close($oExcel) Exit EndIf _ArrayDisplay($aResult) My Excel file has values from Column A to H with values from 1 to 30, what I desired to do is have the value in "A7" assigned on to a variable.
Any help is appreciated. Thanks in advance.
A gui splash screen. Themed after the famous MS Office Suite.
Three colours to choose from, Red, Blue and Green.
You can change the labels to your own application.
Animated side scrolling dots just like MS does.
Also bundled with this is the KODA form. So you can open up and see the basic structure of this splash screen.
MS Splash Screens
The office 2016/17 office suite has made many people turn heads with its functions and especially their splash screen.
I now present to you, the MS Style Splash Screen. For Rookies, Novices and anyone who wants a ready made splash screen for your gui application.
You can now download it and also try it out yourself.
You have three colors to choose from:
All three colours are from the famous programs.
I also included the KODA form to you can have freedom with this splash screen.
Note: the KODA form does not have the three colours as well as the correct blue.
Have fun and enjoy.
Thanks to kaz for updating the side scrolling dots.