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, "[*]", "")
So I have read a few posts and tried different things but I cant get this working.
I have a GUI with a GUICtrlCreateEdit box so I can type in multiple lines.
I then want to write all these lines to a html file (as separate lines but all together in one block.
The whole script is pretty big, but but these are the bits of code im using.
$GUIExtraInfo = GUICtrlCreateEdit("", 10, 65, 250, 80)
$vExtraInfo = GUICtrlRead($GUIExtraInfo)
If $vExtraInfo > "" Then FileWriteLine($Signature, "<span class=" & ">" & $vExtraInfo & "</span><br />")
It all works - and when I use a msg box to read $vExtraInfo I get the text entered as two lines.
But when writing to the file it all comes out on the one line.
I have tried stringsplit and a few other things but dosent seem to work.
Brain wave. Do I a FileWriteLine(........) for each line entered into the GUICtrlCreateEdit????
Not sure how I would implement this.
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 !!