how to make a program stable

[yasha]

expandcollapse popup

$fileoutput = false
while $fileoutput = false
; WinActive("Microsoft Excel")
 WinWaitActive("Microsoft Excel")
 If WinExists ('File in Use') Then
 Send("{ENTER}")
 sleep(100)
 Send("{ENTER}")
 sleep(100)
 Send("{ENTER}")
 WinWaitActive("Microsoft Excel - tmp")
    $title1 = WinGetTitle("Microsoft Excel - tmp", "")
    if fileexists($baantmpdir & "tmp\" & StringMid($title1,19,12) & ".txt") then
        $filetime = filegettime ($baantmpdir & "tmp\" & StringMid($title1,19,12) & ".txt",1,1)
        if $filetime > $nowtime then
            $fileoutput = true
            endif
         EndIf
      EndIf
 If Not  WinExists ('File in Use') Then
    WinActive("Microsoft Excel")
    WinWaitActive("Microsoft Excel")
    Send("{ENTER}")
    sleep(200)
    Send("{ENTER}")
    sleep(200)
    Send("{ENTER}")
    WinWaitActive("Microsoft Excel - tmp")
    $title1 = WinGetTitle("Microsoft Excel - tmp", "")
    if fileexists($baantmpdir & "tmp\" & StringMid($title1,19,12) & ".txt") then
        $filetime = filegettime ($baantmpdir & "tmp\" & StringMid($title1,19,12) & ".txt",1,1)
        if $filetime > $nowtime then
            $fileoutput = true
         EndIf
      EndIf
  EndIf
  FileCopy($baantmpdir & "tmp\" & StringMid($title1,19,12) & ".txt", "J:\OPS\OPS_Share\Planners\2 - Weekly Reports\Auto download\.xls files\Pur " & $YY & $MM & $DD & ".xls", 1)

so my full program runs something and an excel file comes out . my computer has a shared macro which cannot be removed so if i have another excel file open ,every time another excel comes out a file in use window will appear. if i just let my program run and not go to any other excel file my program automatically keys in enter so i dont need to key in enter but if i open another another excel while the program is running it will ask me to press enter any ideas how can i solve this.

[JLogan3o13]

@yasha Please look at the excel functions in the help file. You will thank yourself for using these functions to control Excel at the object level, rather than all of these unreliable Sends.

[caramen]

I am beginner in the excel UDF but i can help you  That will improve my skill so we are both together winners on this hard life 

I can help you to solve the main problem too. 

But i will enforce what JL said you. 

The most "Stable" thing is to use the Water's UDF. Good thing for you. It 's now on in the install pack even in the smaller one if i am not mistaking. 

And the only thing you have to do is : Open help file 

Type inside _Excel_ and read/learn/test ask qestion here if needed.

 

Oh i forgot to say... it wont be easy... so be prepared to hardcode and test. Or maybe it is hard only for me idk   (  Please @JLogan3o13 not the face  )

Edited November 22, 2018 by caramen