Jump to content
Sign in to follow this  
WannaBeGut

Skype - Alert when somebody comes online!

Recommended Posts

WannaBeGut

Hey,

I want the program to make different Actions when some persons come online, depending on the priority you choose in the GUI (1-3). It does not seem to work:

#include <Skype.au3>
#include <ButtonConstants.au3>
#include <EditConstants.au3>
#include <GUIConstantsEx.au3>
#include <StaticConstants.au3>
#include <WindowsConstants.au3>
#Region --- GUI START ---
$mainwin = GUICreate("Skype Notifier", 290, 186, 899, 341)
$label_user1 = GUICtrlCreateLabel("User1:", 16, 16, 63, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$label_user2 = GUICtrlCreateLabel("User2:", 16, 48, 39, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$label_user3 = GUICtrlCreateLabel("User3:", 16, 112, 36, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$label_user4 = GUICtrlCreateLabel("User4:", 16, 80, 34, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$label_user5 = GUICtrlCreateLabel("User5:", 160, 80, 49, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$label_user6 = GUICtrlCreateLabel("User6:", 160, 48, 45, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$label_user7 = GUICtrlCreateLabel("User7:", 160, 16, 32, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$input_priority1 = GUICtrlCreateInput("0", 104, 16, 17, 21)
$input_priority2 = GUICtrlCreateInput("0", 104, 48, 17, 21)
$input_priority3 = GUICtrlCreateInput("0", 104, 80, 17, 21)
$input_priority4 = GUICtrlCreateInput("0", 104, 112, 17, 21)
$label_user8 = GUICtrlCreateLabel("User8:", 160, 112, 61, 18)
GUICtrlSetFont(-1, 9, 400, 0, "Verdana")
$input_priority5 = GUICtrlCreateInput("0", 240, 16, 17, 21)
$input_priority6 = GUICtrlCreateInput("0", 240, 48, 17, 21)
$input_priority7 = GUICtrlCreateInput("0", 240, 80, 17, 21)
$input_priority8 = GUICtrlCreateInput("0", 240, 112, 17, 21)
$button_arrowleft1 = GUICtrlCreateButton("<", 86, 16, 16, 22, $WS_GROUP)
$button_arrowright1 = GUICtrlCreateButton(">", 123, 16, 16, 22, $WS_GROUP)
$button_arrowleft2 = GUICtrlCreateButton("<", 86, 48, 16, 22, $WS_GROUP)
$button_arrowright2 = GUICtrlCreateButton(">", 123, 48, 16, 22, $WS_GROUP)
$button_arrowleft3 = GUICtrlCreateButton("<", 86, 80, 16, 22, $WS_GROUP)
$button_arrowright3 = GUICtrlCreateButton(">", 123, 80, 16, 22, $WS_GROUP)
$button_arrowleft4 = GUICtrlCreateButton("<", 86, 112, 16, 22, $WS_GROUP)
$button_arrowright4 = GUICtrlCreateButton(">", 123, 112, 16, 22, $WS_GROUP)
$button_arrowleft5 = GUICtrlCreateButton("<", 222, 16, 16, 22, $WS_GROUP)
$button_arrowright5 = GUICtrlCreateButton(">", 259, 16, 16, 22, $WS_GROUP)
$button_arrowleft6 = GUICtrlCreateButton("<", 222, 48, 16, 22, $WS_GROUP)
$button_arrowright6 = GUICtrlCreateButton(">", 259, 48, 16, 22, $WS_GROUP)
$button_arrowleft7 = GUICtrlCreateButton("<", 222, 80, 16, 22, $WS_GROUP)
$button_arrowright7 = GUICtrlCreateButton(">", 259, 80, 16, 22, $WS_GROUP)
$button_arrowleft8 = GUICtrlCreateButton("<", 222, 112, 16, 22, $WS_GROUP)
$button_arrowright8 = GUICtrlCreateButton(">", 259, 112, 16, 22, $WS_GROUP)
$button_apply = GUICtrlCreateButton("Apply", 176, 144, 103, 25, $WS_GROUP)
GUICtrlSetFont(-1, 8, 400, 0, "Verdana")
$checkbox_busy = GUICtrlCreateCheckbox("Busy Mode", 16, 144, 89, 25)
GUICtrlSetFont(-1, 8, 400, 0, "Verdana")
$checkbox_logfile = GUICtrlCreateCheckbox("Log File", 112, 144, 65, 25)
GUISetState(@SW_SHOW)
#EndRegion --- GUI END ---
Global $oSkype = ObjCreate("Skype4COM.Skype")
Global $oUser1 = $oSkype.User("User1")
Global $oUser2 = $oSkype.User("User2")
Global $oUser3 = $oSkype.User("User3")
Global $oUser4 = $oSkype.User("User4")
Global $oUser5 = $oSkype.User("User5")
Global $oUser6 = $oSkype.User("User6")
Global $oUser7 = $oSkype.User("User7")
Global $oUser8 = $oSkype.User("User8")
Global $SkypeStatus_Offline = $oSkype.Convert.TextToUserStatus("OFFLINE")
Global $SkypeStatus_Online = $oSkype.Convert.TextToUserStatus("ONLINE")
Global $SkypeStatus_Ringing = $oSkype.Convert.TextToCallStatus("RINGING")
Global $SkypeStatus_Inprogress = $oSkype.Convert.TextToCallStatus("INPROGRESS")
Global $SkypeStatus_Failed = $oSkype.Convert.TextToCallStatus("FAILED")
Global $SkypeStatus_Refused = $oSkype.Convert.TextToCallStatus("REFUSED")
Global $SkypeStatus_Cancelled = $oSkype.Convert.TextToCallStatus("CANCELLED")
Global $SkypeStatus_Finished = $oSkype.Convert.TextToCallStatus("FINISHED")
Global $SkypeStatus_Busy = $oSkype.Convert.TextToCallStatus("BUSY")
Global $SkypeStatus_Available = $oSkype.Convert.TextToAttachmentStatus("AVAILABLE")
Global $SkypeStatus_Invisible = $oSkype.Convert.TextToAttachmentStatus("AVAILABLE")
Global $mutestatus = $oSkype.Mute
Global $inputnumber1 = 0
Global $inputnumber2 = 0
Global $inputnumber3 = 0
Global $inputnumber4 = 0
Global $inputnumber5 = 0
Global $inputnumber6 = 0
Global $inputnumber7 = 0
Global $inputnumber8 = 0
Global $readpriority1 = GUICtrlRead($input_priority1)
Global $readpriority2 = GUICtrlRead($input_priority2)
Global $readpriority3 = GUICtrlRead($input_priority3)
Global $readpriority4 = GUICtrlRead($input_priority4)
Global $readpriority5 = GUICtrlRead($input_priority5)
Global $readpriority6 = GUICtrlRead($input_priority6)
Global $readpriority7 = GUICtrlRead($input_priority7)
Global $readpriority8 = GUICtrlRead($input_priority8)
Global $readcheckboxbusy = GUICtrlRead($checkbox_busy)
Global $readcheckboxlogfile = GUICtrlRead($checkbox_logfile)
Global $checkboxbusy = 0
Global $applystart = 0
Global $checkdone1 = 0

If Not $oSkype.Client.IsRunning Then
    $oSkype.Client.Start()
 EndIf
$oSkype.Attach(5)
If $SkypeStatus_Offline = $oSkype.CurrentUserStatus Then
    $oSkype.ChangeUserStatus($SkypeStatus_Online)
EndIf

 While 1
    $nMsg = GUIGetMsg()
        CheckingProcess()
    Switch $nMsg
        Case $GUI_EVENT_CLOSE
            Exit
        Case $button_apply
            Global $readpriority1 = GUICtrlRead($input_priority1)
            Global $readpriority2 = GUICtrlRead($input_priority2)
            Global $readpriority3 = GUICtrlRead($input_priority3)
            Global $readpriority4 = GUICtrlRead($input_priority4)
            Global $readpriority5 = GUICtrlRead($input_priority5)
            Global $readpriority6 = GUICtrlRead($input_priority6)
            Global $readpriority7 = GUICtrlRead($input_priority7)
            Global $readpriority8 = GUICtrlRead($input_priority8)
            Global $readcheckboxbusy = GUICtrlRead($checkbox_busy)
            Global $readcheckboxlogfile = GUICtrlRead($checkbox_logfile)
            Global $applystart = 1
         Case $button_arrowleft1
            $inputnumber1 = $inputnumber1 - 1
            If $inputnumber1 < 0 then $inputnumber1 = 0
            GUICtrlSetData($input_priority1, $inputnumber1)
         Case $button_arrowright1
            $inputnumber1 = $inputnumber1 + 1
            If $inputnumber1 > 3 then $inputnumber1 = 3
            GUICtrlSetData($input_priority1, $inputnumber1)
         Case $button_arrowleft2
            $inputnumber2 = $inputnumber2 - 1
            If $inputnumber2 < 0 then $inputnumber2 = 0
            GUICtrlSetData($input_priority2, $inputnumber2)
         Case $button_arrowright2
            $inputnumber2 = $inputnumber2 + 1
            If $inputnumber2 > 3 then $inputnumber2 = 3
            GUICtrlSetData($input_priority2, $inputnumber2)
         Case $button_arrowleft3
            $inputnumber3 = $inputnumber3 - 1
            If $inputnumber3 < 0 then $inputnumber3 = 0
            GUICtrlSetData($input_priority3, $inputnumber3)
         Case $button_arrowright3
            $inputnumber3 = $inputnumber3 + 1
            If $inputnumber3 > 3 then $inputnumber3 = 3
            GUICtrlSetData($input_priority3, $inputnumber3)
         Case $button_arrowleft4
            $inputnumber4 = $inputnumber4 - 1
            If $inputnumber4 < 0 then $inputnumber4 = 0
            GUICtrlSetData($input_priority4, $inputnumber4)
         Case $button_arrowright4
            $inputnumber4 = $inputnumber4 + 1
            If $inputnumber4 > 3 then $inputnumber4 = 3
            GUICtrlSetData($input_priority4, $inputnumber4)
         Case $button_arrowleft5
            $inputnumber5 = $inputnumber5 - 1
            If $inputnumber5 < 0 then $inputnumber5 = 0
            GUICtrlSetData($input_priority5, $inputnumber5)
         Case $button_arrowright5
            $inputnumber5 = $inputnumber5 + 1
            If $inputnumber5 > 3 then $inputnumber5 = 3
            GUICtrlSetData($input_priority5, $inputnumber5)
         Case $button_arrowleft6
            $inputnumber6 = $inputnumber6 - 1
            If $inputnumber6 < 0 then $inputnumber6 = 0
            GUICtrlSetData($input_priority6, $inputnumber6)
         Case $button_arrowright6
            $inputnumber6 = $inputnumber6 + 1
            If $inputnumber6 > 3 then $inputnumber6 = 3
            GUICtrlSetData($input_priority6, $inputnumber6)
         Case $button_arrowleft7
            $inputnumber7 = $inputnumber7 - 1
            If $inputnumber7 < 0 then $inputnumber7 = 0
            GUICtrlSetData($input_priority7, $inputnumber7)
         Case $button_arrowright7
            $inputnumber7 = $inputnumber7 + 1
            If $inputnumber7 > 3 then $inputnumber7 = 3
            GUICtrlSetData($input_priority7, $inputnumber7)
         Case $button_arrowleft8
            $inputnumber8 = $inputnumber8 - 1
            If $inputnumber8 < 0 then $inputnumber8 = 0
            GUICtrlSetData($input_priority8, $inputnumber8)
         Case $button_arrowright8
            $inputnumber8 = $inputnumber8 + 1
            If $inputnumber8 > 3 then $inputnumber8 = 3
            GUICtrlSetData($input_priority8, $inputnumber8)
    EndSwitch
 WEnd
 Func CheckingProcess()
            If $applystart = 0 then return
            Global $userstatus1 = $oSkype.Convert.OnlineStatusToText($oUser1.OnlineStatus)
            If $readpriority1 = 1 and $userstatus1 = "Online" or "Busy" then GUICtrlSetData($input_priority1, "!")
            If $readpriority1 = 2 and $userstatus1 = "Online" or "Busy" then  ChatAlert()
            If $readpriority1 = 3 and $checkboxbusy = 0 and $userstatus1 = "Online" or "Busy" then  MsgBox(0, "User Online!", "User1 ist Online!"&Chr(10))
            If $readpriority1 = 3 and $checkboxbusy = 1 and $userstatus1 = "Online" or "Busy" then  ChatAlert2()
            If $userstatus1 = "Do not Disturb" then $userstatus1 = "Busy"
            If $readcheckboxlogfile = 1 and $userstatus1 = "Online" or "Busy" then FileWrite("SkypeLog.txt", @MDAY&"/"&@MON&"/"&@YEAR&"/"&@HOUR&":"&@MIN&":"&@SEC&": "&"User1"&" is "&$userstatus1)

            Global $userstatus2 = $oSkype.Convert.OnlineStatusToText($oUser2.OnlineStatus)
            If $readpriority2 = 1 and $userstatus2 = "Online" or "Busy" then GUICtrlSetData($input_priority1, "!")
            If $readpriority2 = 2 and $userstatus2 = "Online" or "Busy" then ChatAlert()
            If $readpriority2 = 3 and $checkboxbusy = 0 and $userstatus2 = "Online" or "Busy" then MsgBox(0, "User Online!", "User2 ist Online!")
            If $readpriority2 = 3 and $checkboxbusy = 1 and $userstatus2 = "Online" or "Busy" then ChatAlert2()
            If $readcheckboxlogfile = 1 and $userstatus2 = "Online" or "Busy" then FileWrite("SkypeLog.txt", @MDAY&"/"&@MON&"/"&@YEAR&"/"&@HOUR&":"&@MIN&":"&@SEC&": "&"User2"&" is "&$userstatus2)
 EndFunc
 Func ChatAlert()
 EndFunc

 Func ChatAlert2()
 EndFunc

I hope you can help me! =)

Edit: I will make it a bit more neat when I get it to work ^^

Edited by WannaBeGut

Share this post


Link to post
Share on other sites
BrewManNH

What does not seem to work? What is the issue you're seeing?


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites
WannaBeGut

What does not seem to work? What is the issue you're seeing?

It will always think the Users are online, at least the MsgBox always pops up, the interesting thing is: If I display the $userstatus variable in a MsgBox, I can see it always shows the right state of the User (Online, Offline, Busy, Away)

If $readpriority2 = 1 and $userstatus2 = "Online" or "Busy" then GUICtrlSetData($input_priority1, "!")
Edited by WannaBeGut
Correction

Share this post


Link to post
Share on other sites
BrewManNH

Try this change:

If $readpriority1 = 1 and ($userstatus1 = "Online" or $userstatus1 = "Busy") then GUICtrlSetData($input_priority1, "!")

 


If I posted any code, assume that code was written using the latest release version unless stated otherwise. Also, if it doesn't work on XP I can't help with that because I don't have access to XP, and I'm not going to.
Give a programmer the correct code and he can do his work for a day. Teach a programmer to debug and he can do his work for a lifetime - by Chirag Gude
How to ask questions the smart way!

I hereby grant any person the right to use any code I post, that I am the original author of, on the autoitscript.com forums, unless I've specifically stated otherwise in the code or the thread post. If you do use my code all I ask, as a courtesy, is to make note of where you got it from.

Back up and restore Windows user files _Array.au3 - Modified array functions that include support for 2D arrays.  -  ColorChooser - An add-on for SciTE that pops up a color dialog so you can select and paste a color code into a script.  -  Customizable Splashscreen GUI w/Progress Bar - Create a custom "splash screen" GUI with a progress bar and custom label.  -  _FileGetProperty - Retrieve the properties of a file  -  SciTE Toolbar - A toolbar demo for use with the SciTE editor  -  GUIRegisterMsg demo - Demo script to show how to use the Windows messages to interact with controls and your GUI.  -   Latin Square password generator

Share this post


Link to post
Share on other sites
WannaBeGut

Try this change:

If $readpriority1 = 1 and ($userstatus1 = "Online" or $userstatus1 = "Busy") then GUICtrlSetData($input_priority1, "!")

 

Just fixed it! That's what I did: (Thx anyways :D)

Local $userstatus1 = $oSkype.Convert.OnlineStatusToText($oUser1.OnlineStatus)
        If $userstatus1 = "Do Not Disturb" then $userstatus1 = "Busy"
        If $userstatus1 = "Online" then $uservalue1 = "Online"
        If $userstatus1 = "Offline" then $uservalue1 = "Offline"
        If $userstatus1 = "Busy" then $uservalue1 = "Online"
        If $userstatus1 = "Away" then $uservalue1 = "Offline"
        If $readpriority1 = 1 and $uservalue1 = "Online" then GUICtrlSetData($input_priority1, "!")
        If $readpriority1 = 2 and $uservalue1 = "Online" then Msg()
        If $readpriority1 = 3 and $busymode = 0 and $uservalue1 = "Online" then MsgBox(0, "User Online!", "User st Online!")
        If $readpriority1 = 3 and $busymode = 1 and $uservalue1 = "Online" then MsgImportant()

 

Edited by WannaBeGut

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Similar Content

    • 2Toes
      By 2Toes
      Hi all..
      I'm having slight issue that has be a bit puzzled.
      I have an Input control.. After a certain function runs, it Disables that Input control, and sets it to ReadOnly.
      When running another certain function, it re-Enables that Input control, and sets the style back to Default.
      Which does work, however, when typing into the Input control after re-Enabling it, the text appears as a light gray color, rather than its original black color.
      I'm sure there's a simple solution here.. But what that is, appears to be beyond me.
      Here is a simplified example code:
      #include <ButtonConstants.au3> #include <EditConstants.au3> #include <GUIConstantsEx.au3> #include <WindowsConstants.au3> #Region ### START Koda GUI section ### Form= Global $Form1 = GUICreate("Form1", 245, 215, 192, 124) Global $disableBTN = GUICtrlCreateButton("Disable", 32, 64, 75, 25) Global $enableBTN = GUICtrlCreateButton("Enable", 128, 64, 75, 25) Global $Input1 = GUICtrlCreateInput("", 32, 120, 169, 21) GUISetState(@SW_SHOW) #EndRegion ### END Koda GUI section ### While 1 $nMsg = GUIGetMsg() Switch $nMsg Case $GUI_EVENT_CLOSE Exit Case $disableBTN disable() Case $enableBTN enable() EndSwitch WEnd Func disable() GUICtrlSetState($Input1, $GUI_DISABLE) GUICtrlSetStyle($Input1, $ES_READONLY) EndFunc Func enable() GUICtrlSetState($Input1, $GUI_ENABLE) GUICtrlSetStyle($Input1, $GUI_SS_DEFAULT_INPUT) EndFunc  
      Any help would be greatly appreciated
      Thank you in advance!
    • MFrancisca
      By MFrancisca
      Hello! 
      I've been checking the logging UDFs in the wiki, mostly Log4a and Loga and I wanted to ask which one would you recommend for a script that will be executed remotely through PSExec. My main question is where the logs are located in that situation and if I can change that location to a custom one., because I need to retrieve them at the end of execution.
      So in a rough description the process is
      Open PSExec
      Send compiled AutoIT script to remote machine
      Execute script
      Copy logs from the remote to the local machine.
       
      Any opinions? 
    • jantograaf
      By jantograaf
      Hi all,
      I'm trying to create a script that runs a JSON-query and then can retrieve some variables out of the returned, decoded object using JSON.au3. I have tried some other examples on this forum, but I'm stuck at one point. My query works perfectly and gets loaded into the variable $data. Then, decoding $data to $object seems to work as well. But then I can't get the date-field out of this JSON-structure with my script.
      The JSON-structure returned looks like this:
      { "content": [ { "id": "451ec583-8f27-4926-82a3-a2d85e57a110", "createdDate": "2018-08-08T08:40:57.449004Z", "updatedDate": "2018-08-08T08:40:57.449004Z", "lastOpenedDate": "2018-08-08T08:40:57.449004Z", "date": "2018-04-26T00:00:00", "description": "X-Ray Exam", "patient": { "id": "f857238a-c75d-4760-b8d1-8f50f8f9bbfa", "createdDate": "2018-08-08T08:40:37.623976Z", "updatedDate": "2018-08-08T08:40:37.623976Z", "lastOpenedDate": "2018-08-08T08:40:37.623976Z", "name": "Fuerstonia", "birthDate": "2014-06-08", "breed": "", "chip": "", "color": "", "damsire": "", "sire": "", "neutered": false, "orthancUuid": "", "sex": "U", "species": "Paard", "ueln": "De 431310762114", "pmsReference": "", "origin": "" }, "type": "study", "accessionNumber": "KME201806960467", "instanceUid": null, "orthancUuid": "", "sent": false, "seriesCount": 0, "modalityType": "RX", "typeAndModality": "study RX", "client": { "id": "be627195-8458-4927-8446-f1ef37b917a4", "createdDate": "2018-08-08T08:40:31.433968Z", "updatedDate": "2018-08-08T08:40:31.433968Z", "lastOpenedDate": "2018-08-08T09:26:49.512298Z", "via": "", "extraInfo": "", "pmsReference": "", "contact": { "id": "406cc555-c491-4c29-b6bb-8d903f0e35a9", "createdDate": "2018-08-08T08:40:31.428968Z", "updatedDate": "2018-08-08T08:40:31.428968Z", "lastName": "Client 1", "firstName": "", "company": "", "email": "", "language": "nl", "phone": "", "address": { "id": "6fc7703c-137a-4e0a-ba96-8c7f38f2044b", "city": "", "country": "", "line": "", "postalCode": "" } } } }, My script looks like this:
      #RequireAdmin #include <json.au3> #include <inet.au3> #include <File.au3> ;Create a handle to a logfile (will be created if it doesnt exist) Global $logfile = FileOpen("C:\VSOL\VSTK\Logs\MigrationFix\MigrationFix.log",9) FileWriteLine($logfile,"Start script") ;Create the URL with the JSON-query $URL = "http://localhost:8080/v0/studies/?seriesCount=1" ;Catch the query output into a variable $data = _INetGetSource($URL) ;Check if there is any data at all in this variable, if not, exit If Not $data Then MsgBox(1,"Error","No answer. Server is probably not running.") Exit EndIf ;For debugging purposes FileWriteLine($logfile,$data) ;Decode the JSON_string into a useable object $object = Json_Decode($data,1000) If @error Then FileWriteLine($logfile,"Error decoding JSON") Exit EndIf Local $i = 0 ;Start a loop to retrieve the study date of each study... While 1 $study_date = json_get($object,'[' & $i & '].date') If @error Then FileWriteLine($logfile,"Study-Date retrieval error") ExitLoop EndIf $i = $i + 1 WEnd ;Close the logfile FileWriteLine($logfile,"Stop script") FileClose($logfile) ;Open the logfile for quick reference ShellExecute("C:\VSOL\VSTK\Logs\MigrationFix\MigrationFix.log") If believe it has something to do with my json_get($object...)-command. Anyone who can point me in the right direction?
      Thanks in advance!
      Kind regards
    • gahhon
      By gahhon
      Hi Guys,
      I was trying to read some data from the excel file and without opening the file. But I tried a lot of methods, it still open the file.
      And also, I am able to capture the ColumnA value but not Column B.
      Thanks for advance information.
      Global $oDataA, $oDataB Call ("ExcelRead", "B2", "C2") Func ExcelRead($oColumnA, $oColumnB) Local $oPath = @ScriptDir & "\MyFile.xlsx" Local $oExcel = _Excel_Open() Local $oWorkbook = _Excel_BookOpen($oExcel, $oPath, 1, 0) $oDataA = _Excel_RangeRead($oWorkbook, "Sheet 1", $oColumnA) $oDataB = _Excel_RangeRead($oWorkbook, "Sheet 1", $oColumnB) MsgBox(0, "Test Value", $oDataA & ", " & $oDataB) EndFunc  
    • SharpDressedMan
      By SharpDressedMan
      I have an array of subarrays, eg:
      local $a[3] = [ 1, 2, 3 ] local $b[3] = [ 4, 5, 6 ] local $c[2] = [ $a, $b ] I can read read a subarray element of the array, as follows:
      local $c12 = ($c[1])[2] ; result: $c12 = 6 However, when I try to set a subarray element as follows, it fails:
      ($c[1])[2] = 12 ; this fails to set subarray element local $c12 = ($c[1])[2] ; result: $c12 = 6 How to set a subarray element ?
      Thanks
×