If this issue has been addressed before, please excuse the repetition and point me to the correct thread.

I have created an Excel 2000 application which serves to extract data from an Oracle instance, perform some fairly simple transformations, and then display the data in a report. The workbook has four worksheets. The first is the report template, the second and third are various named ranges containing values to be used for list boxes on a user form, and the fourth the target area for the results of the Oracle query (including various formulae). The workbook open event brings a user form to the foreground that collects information needed for the query to the Oracle instance. The VBA code behind the form then executes the query via ADO, copies the information into the hidden target sheet, fills in needed formulae, and copy/pastes the results into the report template sheet that the user may view. The code is tedious, but not terribly complex.

When opened from Excel or Windows Explorer from a location on the local hard drive or network share, the application functions perfectly well. When placed on a virtual drive and accessed via a URL through IE 6.0, the application displays unusual behavior. If an Excel object is instantiated, IE opens the application in the IE window, displays the user form briefly, and then pushes the user form behind the IE window. If no Excel object is instantiated, Excel is started and the application displays in Excel with the user form appropriately displayed.

I was able to solve the display problem by adding a button to the application that shows the form. However, after doing so, the form fails to find one (but not all) of the named ranges that are the sources for its list boxes. I am at wits end and without strong IT support for this particular problem.

Any advice sincerely appreciated.