macro- windows scheduler

[boumbo]

windows scheduler:- macro
I have configured windows schedule to open a workbook and in the open event of the workbook i have the following code:-

Private Sub Workbook_Open()
MsgBox "TESTING"
End Sub

The windows scheduler opens the excel and I can see the excel open in the taskbar. But the excel keeps blinking.

I can only get the TESTING open box msg if i click the excel tab in the taskbar with my mouse.

how do i get the testing automsg box without the need to click on the excel taskbar. I want to automate this without human intervention.

 

[MarkK]

I don't believe that windows allows a program being automated to intrude like that. Msgbox is a modal dialog. If programs other than the one you're currently using could present modal dialogs at will, you'd hate it. Try to write something to the immediate window using debug.print rather than open a modal dialog to test your process. And if you don't want humans involved in the process you won't want to open a message box.
HTH