Home     Products      Support      Corporate     Sign In 
Support Knowledge Base, Article 1179
Product
ExcelWriter
Version
Any
Title
Excel hidden behind browser window in Windows XP, SP2 when downloading multiple spreadsheets.
Problem

This is a very specific problem that will only occur if the spreadsheet being download contains VBA code/macros, and a spreadsheet is being downloaded and opened directly into Excel when another spreadsheet has already been opened.

The Excel document will download an open properly, but it will be behind the IE window. An unknown bug with IE seems to prevent the most recently opened Excel window from taking precedence in the Z order of the windows on screen.

Solution

The are a few possible work arounds.

  • Setting the macro security level of Excel to Low or removing any VBA from the spreadsheet will solve the problem. If security is medium or high, the spreadsheets will continue opening in window behind the browser window.
  • Another solution would be to use the OfficeWriter Assistant to do a reliable download. Documentation on the OfficeWriter Assistant can be found here:

    http://support.softartisans.com/OfficeWriter/OfficeWriterAssistant/WebHelp/Index.html

  • A final option is to use additional VBA to minimize and re-maximize the Excel window when the spreadsheet is loaded. This will bring the sheet to the front of the Z-order and it will no longer be behind any other windows. Here is an example of how this could be done in VBA:

    
    Sub Auto_Open()
       ActiveWindow.WindowState = xlMinimized
       ActiveWindow.WindowState = xlMaximized
    End Sub
    
    

Related Links
OfficeWriter Home Page
Purchase OfficeWriter
OfficeWriter Enterprise Edition
Latest OfficeWriter News

Created : 9/6/2005 11:56:00 AM (last modified : 9/8/2005 12:19:09 PM)
Rate this article!
Comments