Access Global Variable inside a Function

[MK_2019]

Hello,

Am New to AutoIT, I Tried to search for Solution in the Forum, But could Not find.
Hence, Posting this Query.
I Have Different .au3 Files (Main.au3, File2.au3)
Am calling File2.au3 from Main.au3.
Am trying to increment the "$cell" value in Main.au3, so that, the value is captured in next cell of spreadsheet.
The Problem is, Even-though i have Declared Global Variable value (for $cell) in Main.au3,.. Local variable value (for $cell) From File2.au3 is Displayed in Spreadsheet... And $cell value is NOT getting Incremented.
Am Expecting Global Variable Value (for $cell) and increment in Main.au3.
Any Help is appreciated.

;~    <File2.au3>
;~.......... <File2.au3> ..........
    Local $cell = 1
    Local $Description ="TTT3"
         
        Local $var = "C:\AutoIT_Excel_Report\Book3.xlsx"
        Local $oExcel = _Excel_Open (True)
        Local $oWorkbook = _Excel_BookOpen ($oExcel, $var)
    
    $range = _Excel_RangeWrite ($oWorkbook, Default, $Description, "A" &$cell)
        
        _Excel_BookSave ($oWorkbook)
        Sleep (2000)
        _Excel_BookClose ($oWorkbook)
        Sleep(2000)
        _Excel_Close ($oExcel)
            
    $cell +=1
;~.......... <File2.au3> ..........

 

;~    <Main.au3>    
;~.......... <Main.au3> ..........
    #include <File2.au3>
    
    Global $cell = 4
    Global $Description = "Desc"
    
    $sFilePath = "C:\xxx\xxx\File2.au3"
    
    Func _Report($sFilePath, $sWorkingDir = "", $iShowFlag = @SW_SHOW, $iOptFlag = 0)
        Return Run('"' & @AutoItExe & '" /AutoIt3ExecuteScript "' & $sFilePath & '"', $sWorkingDir, $iShowFlag, $iOptFlag)
    EndFunc
    
    If <Condition1> Then
    
        <Action1....>
        _Report("C:\xxx\xxx\File2.au3")
    
    EndIf
    
    $cell +=1
    
    If <Condition2> Then
    
    <Action2....>
        _Report("C:\xxx\xxx\File2.au3")
    
    EndIf
;~ .......... <Main.au3> ..........

[BrewManNH]

Is the variable $cell declared local inside a function in script File2?

 

Also, when posting code, use the code block in the editor "<>" button, it makes things much easier to read.

[Danp2]

8 minutes ago, MK_2019 said:

Am calling File2.au3 from Main.au3.

Technically, you are including the one file into the other. Therefore, I believe the two attempts to declare the variable will occur at the same level and only one instance actually exists.

[MK_2019]

Yes.. $cell is declared as Local in Script File2.au3

[Bowmore]

;~.......... <File2.au3> ..........
    Local $cell = 1
    Local $Description ="TTT3"
         
        Local $var = "C:\AutoIT_Excel_Report\Book3.xlsx"
        Local $oExcel = _Excel_Open (True)
        Local $oWorkbook = _Excel_BookOpen ($oExcel, $var)

These variables you have declared in File2.au3 as Local are in fact Global. AutoIt  treats all variable declared outside a function as Global. There is no file scoping in AutoIt like some other languages. 

[MK_2019]

Thank You for Reply... Have Moved the scripts into a Function ( _File() in File2.au3 ).. And have declared variables as Local inside Function ( _File() )... But still issue Remain.... $cell value is still considered from local... Not getting incremented....

Is below Script correct?? Or am i missing something??

;~    <File2.au3>
;~.......... <File2.au3> ..........

Func _File()
    Local $cell = 1
    Local $Description ="TTT3"
         
        Local $var = "C:\AutoIT_Excel_Report\Book3.xlsx"
        Local $oExcel = _Excel_Open (True)
        Local $oWorkbook = _Excel_BookOpen ($oExcel, $var)
    
    $range = _Excel_RangeWrite ($oWorkbook, Default, $Description, "A" &$cell)
        
        _Excel_BookSave ($oWorkbook)
        Sleep (2000)
        _Excel_BookClose ($oWorkbook)
        Sleep(2000)
        _Excel_Close ($oExcel)
            
EndFunc

_File ()

;~.......... <File2.au3> ..........

 

 

[Network_Guy]

On 8/9/2019 at 12:38 PM, MK_2019 said:

Func _Report($sFilePath, $sWorkingDir = "", $iShowFlag = @SW_SHOW, $iOptFlag = 0)
        Return Run('"' & @AutoItExe & '" /AutoIt3ExecuteScript "' & $sFilePath & '"', $sWorkingDir, $iShowFlag, $iOptFlag)
    EndFunc

you run file2.au3 in a new process which have a totally separated memory . 

[MK_2019]

Hello Network_Guy....,  It would be appreciable, if you can share a script (for Reference) from which i could Run new process in totally seperate memory....

[Network_Guy]

using Run() will run new process in totally separated memory and thats the reason for your problem with $cell . i cant rly get what are you trying to do with this script , but here is mini example for calling function from included au3 with shared global variable.

Main

#include<test.au3>

Global $var=0

for $i =0 to 2
    _Function()
    $var+=1
next

Include(test.au3)

#include-once

func _function()
MsgBox(0,"",$var)
EndFunc

 

Edited August 11, 2019 by Network_Guy

[MK_2019]

 

Hello Network_Guy.... You were Correct.., The Problem was "Return Run()"... it was creating a Separate memory...

Also, I changed Variable (in Function) to "Dim" from "Local"...

Below are the Modified Script  i was able to Run the Script and get desired Expected Result... 

Thank You and All in the Thread for your suggestions... 

******.......... <Main.au3> ..........******

#RequireAdmin

    Global $cell = 6
    Global $Description ="Global"
    $sFilePath = "C:\xxx\xxx\file2.au3"
    #include <file2.au3>

    ;Func _Report($sFilePath, $sWorkingDir = "", $iShowFlag = @SW_SHOW, $iOptFlag = 0)
    ;    Return Run('"' & @AutoItExe & '" /AutoIt3ExecuteScript "' & $sFilePath & '"', $sWorkingDir, $iShowFlag, $iOptFlag)
    ;EndFunc

$cell +=1
    For $i =0 to 2
        $Description = "i"&$cell
        _File()
        $i +=1
    $cell +=1
    Next

    For $r =0 to 2
        $Description = "r"&$cell
        _File()
        $r +=1
    $cell +=1
    Next

    For $k =0 To 2
        $Description = "k"&$cell
        _File()
        $k +=1
    $cell +=1
    Next

******.......... <Main.au3> ..........******

******......... <file2.au3> ..........******

#RequireAdmin
;#include-once
#include <excel.au3>

_File()

Func _File()
    Sleep (2000)
    Dim $cell
    Dim $Description
        Local $var = "C:\xxx\Book3.xlsx"
        Local $oExcel = _Excel_Open (True)
        Local $oWorkbook = _Excel_BookOpen ($oExcel, $var)

    $range = _Excel_RangeWrite ($oWorkbook, Default, $Description, "A" &$cell)

        _Excel_BookSave ($oWorkbook)
        Sleep (2000)
        _Excel_BookClose ($oWorkbook)
        Sleep(2000)
        _Excel_Close ($oExcel)
        Sleep (2000)

EndFunc

******.......... <file2.au3> ..........******

 

Edited August 11, 2019 by MK_2019

[BrewManNH]

On 8/10/2019 at 11:34 PM, MK_2019 said:

And have declared variables as Local inside Function ( _File() )... But still issue Remain.... $cell value is still considered from local... Not getting incremented....

A local variable with the same name as the Global variable will cause the local version to be used inside the function. Why are you redeclaring the variable $cell inside the function if you want to use the global version of it?