Groups | Blog | Home
all groups > dotnet interop > october 2004 >

dotnet interop : 2nd Post - Any Help Here


DavidS
10/20/2004 7:13:07 AM
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.

Daniel Garcia
10/20/2004 8:55:08 AM
How are you opeing the excel file? SP2 has a problem with downloading files
unless some security settings are changed.

[quoted text, click to view]
Sunny
10/20/2004 9:43:00 AM
In article <3BA529D8-6EF7-442C-847F-E8F82C315E39@microsoft.com>,
DavidS@discussions.microsoft.com says...
[quoted text, click to view]

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.

Robert Jordan
10/20/2004 4:44:29 PM
[quoted text, click to view]

Where to you want to see the Excel window??

bye
AddThis Social Bookmark Button