Can't get excel file to come to front

[THEgame32]

expandcollapse popup

Dim $input

;Loop until they hit cancel.
While @error <> 1

;Get input from the scanner
$input = InputBox("Andy's Amazing Oven Logger Robot", "Scan Work Order Here:","","",300,130,0,0)
;If we actually scanned something, then proceed.
   If $input Then


         If Not ProcessExists("WatchMe.exe") Then Run ("WatchMe.exe")
            Sleep(1500)





         ;Activate Keyed import window
         WinActivate("Microsoft Excel - Oven Log Test")
         WinWaitActive("Microsoft Excel - Oven Log Test")

         ;Navigate to top of Work Order column
         Send("{F5}")
         Sleep(200)
         Send("B1")
         Sleep(200)
         Send("{ENTER}")

         ;Navigate to bottom of Work Order Column
         Send("{CTRLDOWN}{DOWN}{CTRLUP}{DOWN}")


         ;Input the WorkOrder in Excel
         Send($input)
         Sleep(1000)
         Send("{TAB}")
         Sleep(1000)




      EndIf


   WEnd

 

 

That's my current code.  It doesn't matter what I put where at the end of the code, I can't get anything other than my inputbox to be in the frontground.  I want my open excel file to jump to the front after all that code runs.

[water]

Welcome to AutoIt and the forum!

AutoIt comes with an UDF (User Defined Functions) to work with Excel. To add data to Excel i suggest to use function _Excel_RangeWrite.

[THEgame32]

My script works fine, I just want the excel document to remain in the forefront. 

[water]

The Send statement sends data to an active window. As your script works so Excel is the active window until the script ends.
Is there another statement that takes the focus?
Did you post the whole script?
 

[THEgame32]

I posted the entire thing... I assure you, Excel is not active at the end.  After I send the Tab and sleep for 1000, the InputBox becomes active again.

[Jos]

So which other window sits in front of excel then?  Maybe it has the TOPMOST attrib set?

Jos

[THEgame32]

The Inputbox I generated sits on top once my script is done.  It's never REALLY done, that box should always be there until I hit cancel... it's just that it always gets put back on time.

[THEgame32]

on top*

[water]

Then we need more information:
Which version of Windows do you run?

[water]

Another question:
What does WatchMe.exe do? Could you try without calling this exe?

[THEgame32]

Same results.  WatchMe.exe is just a stand-alone countdown timer.

 

I use Windows 7 Pro

[Jos]

You are not giving answers the our questions and we have no idea what you are trying!

Jos

[THEgame32]

haha, how can you say I'm not answering you?  I've included ALL of the code for the script.  I've tried everything that's been suggested so far.  Not sure how to make that any more clear for you.

Everything suggested has resulted in the same thing: When the script finishes, my inputbox gui is still on top, EVEN THOUGH IT'S NOT THE LAST THING TOUCHED.  I want the excel file to be on top until somebody clicks on my input box again.

[water]

When you enter some data into your InputBox and click OK the Inputbox is closed. You then transfer the data to Excel (means Excel is the active window). Then the loop starts again and the InputBox gets created again (means it becomes the active window).
To sum it up: WAD

You can only solve this problem by creating a GUI.