Hello community I just started to read the Powershell in a month of lunches book, I want to learn Powershell and make Gui's to execute Powershell scripts, I know that AutoIt is capable for a lot of things included Gui's, My question is how to start my journey, I have no prior programming experience, should I learn only powershell first and then jump to AutoIt, and are there any books for AutoIt, and more important where can I find a Gui builder for AutoIt, I read somewhere for KODA but I can't find it.
Any help/advice will be much appreciated.
I am relatively new to the world of Microsoft Office and the Excel UDF.
I am trying to loop through every row in a spreadsheet and get the text/values from each column in the given row... so far I have looked into the Help file for the Excel UDF and the wiki page for Excel UDF but I have no idea about how this is done ... This is all I have in my script:
Global $oExcel = _Excel_Open(False, False, False, False, True) Global Const $sSpreadsheet = @ScriptDir & '\data.xlsx' Global $oSpreadsheet = _Excel_BookOpen($oExcel, $sSpreadsheet, True, False) ; ... I am placing my bet on the _Excel_Range functions... especially _Excel_RangeRead. I don't know how $vRange works so I would be glad if someone can point me in the right direction . What I would ideally like is to get all of the contents of the spreadsheet (it's just a normal text one) in a 2D array.
Thanks in Advance!
I am trying to call my first DLL function but it won't work , I am trying to call GetFinalPathNameByHandle
$sFile = @DesktopDir & '\Test.txt' $hFile = FileOpen($sFile) $sFilePath = "" DllCall("Kernel32.dll", "STR", "GetFinalPathNameByHandle", "HANDLE", $hFile, "sz*", $sFilePath) MsgBox(0, 0, @error) Thanks in Advance, TD
It's 5:30 AM and been sitting here staring at the help file but it looks like an alien language to me.
I have the following example strings
Bird Cat Dog
What I want is
Bird Cat Dog
Now a easy solution would be to just trim it to the left by 3, however there are cases when it could be 4 (example Dog being ), so I figured StringRegExpReplace() is what I am going to have to use unless there is a easier/better method.
I don't know how or where to start though
StringRegExpReplace($String, "[*]", "")
Need help logging into the web interface of my WhatsUP gold server for an overhead display in our IT dept.
Essentially I want the script to open IE, navigate to our servers web address, login to whats up, then kill IE and start the process over. ( only because the web interface times out after about 10 mins and logs you out )
Currently I have this:
Dim $oIE = _IECreate('about:blank', 0, 0)
.Left = 0
.Top = 0
.Menubar = False
.Resizable = False
.StatusBar = False
.TheaterMode = True
.Toolbar = False
.Visible = True
I AM STUCK please help !!