Cannot Open Excel File

Looch · Jun 4, 2007

Was hoping I could get some insight on this. I added a text box and
command button to a web page and added the code in the .vb file to
open an existing Excel file based on what was typed in the text box.

I'm getting the

I'm new to ASP so...

Can I have the Excel file anywhere or does it have to be in an IIS/ASP
related folder? (Getting the ASP user not authorized 80070005 error)

I've added every user (IUSR_machinename) and permission I possibly can
and still can't get it to open. (The same code works in a VB app that
I wrote and copied it from).

Thanks for any advice.

Mark Rae · Jun 4, 2007

Was hoping I could get some insight on this. I added a text box and
command button to a web page and added the code in the .vb file to
open an existing Excel file based on what was typed in the text box.

I'm getting the

I'm new to ASP so...

Can I have the Excel file anywhere or does it have to be in an IIS/ASP
related folder? (Getting the ASP user not authorized 80070005 error)

I've added every user (IUSR_machinename) and permission I possibly can
and still can't get it to open. (The same code works in a VB app that
I wrote and copied it from).

Presumably, you're trying to do server-side automation? Microsoft doesn't
support this because it doesn't work:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

Fortunately, there are several other possibilities depending on what you are
trying to do...

What are your requirements for interfacing ASP.NET and Excel...?

Looch · Jun 4, 2007

Mark,

Thanks for your response. The interface between ASP and Excel is very
simple, the only requirement is to open an Excel file who's name
matches the text in the text box. It can either open in the same or a
new window (new preferably) or could open Excel and open the workbook
that way. I was trying to use server-side b/c I'm fairly familiar with
vb.net while my experience with ASP is next to nothing!

Mark Rae · Jun 4, 2007

Thanks for your response. The interface between ASP and Excel is very
simple, the only requirement is to open an Excel file who's name
matches the text in the text box. It can either open in the same or a
new window (new preferably) or could open Excel and open the workbook
that way.

Do you need to do anything other than open an Excel workbook in a browser
window...?

I was trying to use server-side b/c I'm fairly familiar with
vb.net while my experience with ASP is next to nothing!

Sure, but you can't do that because it doesn't work - see the Microsoft
support article which explains this...

Steve C. Orr [MCSD, MVP, CSM, ASP Insider] · Jun 4, 2007

It would help to see a code sample demonstrating how you're trying to do it.
Meanwhile, I'd suggest you take a look at Response.WriteFile, which will
allow you to store the Excel file pretty much anywhere on the server.
Here's more info:
http://msdn2.microsoft.com/en-us/library/aa332830(vs.71).aspx

Looch · Jun 4, 2007

Do you need to do anything other than open an Excel workbook in a browser
window...?

Just need to open a pre-existing Excel file with the name that matches
what would be entered into a text box.

Looch · Jun 4, 2007

It would help to see a code sample demonstrating how you're trying to do it.
Meanwhile, I'd suggest you take a look at Response.WriteFile, which will
allow you to store the Excel file pretty much anywhere on the server.
Here's more info:http://msdn2.microsoft.com/en-us/library/aa332830(vs.71).aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsiderhttp://SteveOrr.net

- Show quoted text -

Here's the code I'm using. If I just use a simple HTM file the script
code works, but not in an ASP app. I get an error on page message in
the bottom left.

<head runat="server">
<title>Untitled Page</title>
<script language =vbscript >
dim objExcel
Sub cmdOrderFrm_onclick()
call OpenWorkbook("C:Temp\test.xls")
end sub

sub OpenWorkbook(strLocation)
set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open (strLocation)
objExcel.UserControl = true
end sub
</script>
</head>

.....

<body>
.....
<input type =button name=cmdOrderFrm value = "OK" style="z-index:
103; left: 173px; position: absolute; top: 337px" />

</body>

Steve C. Orr [MCSD, MVP, CSM, ASP Insider] · Jun 4, 2007

Using client side code for this (as you are attempting) is fraught with a
variety of security related problems.
Therefore I'd suggest using a server side technique like response.WriteFile
instead.

Mark Rae · Jun 4, 2007

Just need to open a pre-existing Excel file with the name that matches
what would be entered into a text box.

Presumably, this Excel file is on the webserver somewhere...?

Looch · Jun 4, 2007

Presumably, this Excel file is on the webserver somewhere...?

Yes. (Would like to move to a separate file server at some point but
on the webserver (IIS on Win XP Pro) for now is ok).

PDF file won't open	1	Jun 21, 2022
I want to make such a page in which i can put my excel file.	1	Jun 23, 2023
I want to Display Excel As HTML In js	2	Feb 24, 2023
Collect Excel Data from Website	5	Apr 30, 2022
How to loop in folder through all excel files and all sheets using pandas?	0	Dec 1, 2022
Text File Only Programming	1	May 10, 2023
How can I view / open / render / display a pdf file with c code?	0	Sep 23, 2023
Open Excel file as read only	3	Nov 14, 2008

Cannot Open Excel File

Looch

Mark Rae

Looch

Mark Rae

Steve C. Orr [MCSD, MVP, CSM, ASP Insider]

Looch

Looch

Steve C. Orr [MCSD, MVP, CSM, ASP Insider]

Mark Rae

Looch

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads