In article <3BA529D8-6EF7-442C-847F-E8F82C315E39@microsoft.com>,
DavidS@discussions.microsoft.com says...
[quoted text, click to view] > Have Excel document that I attempt to open using Interop Assemblies with
> ASP.NET. Problem is Excel is opened but is not visible from web app.
> Code used is as follows:
> Dim oExcel As New Excel.ApplicationClass()
> Dim oBooks As Excel.Workbooks
> oBook.Open( "some excel report" )
> oExcel.Visible = True
> oExcel.UserControl = True
> What do I need to do to ensure report is visible.
>
>
>
Hi,
visible to whom? ASP.NET application is running under ASPNET user
account. This is different from the logged in user, which owns the
desktop, so you can not just open a window in the current desktop.
If you need to display the report in the users browser, then maybe a
right thing to do is to use ACrobat, and to use Excel automation to
print the report to a pdf file, and the offer the file to the user.