Progress bar for each execution of file completed?

[soonyee91]

Based on the help file, the example of the progress bar is progress with "sleep(1000)" which is 1 second.

Any idea to create a progress bar for each of my file execution complete?

Case $msg = $btn_action
         If $ordner <>0 then
            For $i In $ordner
               Local $oExcel = _ExcelBookOpen($i);open the excel File
               sleep (1000)
               _ExcelBookClose($oExcel)
            Next
         endif
   EndSelect
WEnd 

Based on the above code structures, I will receive array of files stored in $ordner. It will keep on looping until there is no files.

Any idea to create a progress bar which will be updated upon each file execution is complete?

 

[Melba23]

soonyee91,

As you know the number of files in the array, you can do this quite easily. I seem to remember that you like hints - so here we go:

- Create your progress bar and then each time you start a new pass through the loop move the progress bar a suitable distance - the maths are here if you need to peek:

$iInterval = Int(100 / UBound($aArray))
For $i = 1 To UBound($aArray)
    GUICtrlSetData($cProgress, $iInterval * $i)
    ; Do whatever you need to the array element
    Sleep(1000) ; This just to slow this example
Next

All clear?

 

M23

[soonyee91]

Thanks for the great hint!

However, I encounter a small problem.

If I want to perform loop on each of my files then my progress bar cannot reach to the full due to this: "Ubound($ordner)-1"

If I do not put minus one on the Ubound then the code will fail. 

Any idea to solve this issue?

$iInterval = Int(100 / UBound($ordner))
For $i = 0 To UBound($ordner)-1
    GUICtrlSetData($bar1, $iInterval*$i)
    ; Do whatever you need to the array element
    ;Sleep(1000) ; This just to slow this example
    Local $oExcel = _ExcelBookOpen($ordner[$i]);open the excel File
        sleep (1000)
    _ExcelBookClose($oExcel)
            
Next
         

[Melba23]

soonyee91,

Just increase the counter value when calculating the progress bar value:

GUICtrlSetData($bar1, $iInterval * ($i + 1))

Now you should get the bar filling.

M23

[soonyee91]

Thanks again for your quick reply!

Do think of adding back one to the variable but don't know where to put it.

You are really helpful!