7 posts in this topic
I'm trying to insert the following formula in cell A2 using my script:
=if(A1=""; "YES"; "NO")
To my understanding, the line of code should be similar to this:
_Excel_RangeWrite($MasterFile, Default, "=if(A1=""; "YES"; "NO")", "A2")
However, it does not work, probably due to the multiple quotation marks that confuse the script :C
How do I avoid this problem?
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.
I will update the splash to add the automated 3 dots animation at a later stage.
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.
Also bundled with this is the KODA form. So you can open up and see the basic structure of this splash screen.
Splash Screen GUI.zip
i have a question about Excel, i have to create several charts one below the other dynamically.
I have thought to use:
$oRangeLast = .UsedRange.SpecialCells($xlCellTypeLastCell) $iRowCount = .Range(.Cells(1, 1), .Cells($oRangeLast.Row, $oRangeLast.Column)).Rows.Count
And then to use it in this way:
$Graph_position = "=Test1!A"&$iRowCount+2&":K"&$iRowCount+24 But it doesn't work with charts.
Does anyone have a suggestion?
i have an empty csv file, i have a non formatted text file.
What do i want to do?
I want to automate the process "get external data" in Excel, i want to import the data from the text file and basically create a csv file with a specific character encoding.
Is it possible with AutoIT?