Change Explorer Status Bar When Opening Excel

[ARCITS]

We have an Excel spreadsheet on a network which opens in an IE shell.

The problem is that before the spreadsheet is displayed it has to refresh an inbuilt query which takes around 1 minute.

During this time it would be nice to display a message in IE's status bar to inform the user as to what is happening.

What currenmtly happens is that screen updating stops and the user is left with a blank IE window and wondering whether their PC has crashed or not.

Any ideas on how we could tackle this problem.


Cheers

 

[VBAjedi]

Not too familiar with opening Excel docs inside a browser, but it sounds like you might be able to use Excels "Autpen" event to display a small form which gave the desired message to the user.

To test this, add a blank module into your document and paste the following code:

Public Sub Auto_Open()
   MsgBox("Auto_Open event triggered")
End Sub

Save the workbook, then open it inside the browser. If the messagebox appears, you can replace that line of code with a little routine that displays a small message form, refreshes the tables, then hides the form.

Hope that's a useable idea. . .


VBAjedi