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.

Arlie,

You could write some vbscript which does a
CreateObject("Excel.Application"), sets it's Visible property to True and
opens the worksheet.

Rob


"Arlie" wrote in message
...
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.