Cannot Open Excel File

[Looch]

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_machinena me) 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]

"Looch" <lu**********@y ahoo.comwrote in message
news:11******** *************@h 2g2000hsg.googl egroups.com...

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_machinena me) 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...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...?
--
http://www.markrae.net

[Looch]

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]

"Looch" <lu**********@y ahoo.comwrote in message
news:11******** **************@ q75g2000hsh.goo glegroups.com.. .

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...
--
http://www.markrae.net

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

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.WriteF ile, 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/lib...30(vs.71).aspx

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"Looch" <lu**********@y ahoo.comwrote in message
news:11******** *************@h 2g2000hsg.googl egroups.com...

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_machinena me) 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.

[Looch]

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]

On Jun 4, 12:53 pm, "Steve C. Orr [MCSD, MVP, CSM, ASP Insider]"
<[e-mail] ote:

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.WriteF ile, 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/lib...30(vs.71).aspx

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

"Looch" <lucianoj2...@y ahoo.comwrote in message

news:11******** *************@h 2g2000hsg.googl egroups.com...

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_machinena me) 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.- Hide quoted text -

- 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>Untitl ed Page</title>
<script language =vbscript >
dim objExcel
Sub cmdOrderFrm_onc lick()
call OpenWorkbook("C :Temp\test.xls" )
end sub

sub OpenWorkbook(st rLocation)
set objExcel = CreateObject("E xcel.Applicatio n")
objExcel.Visibl e = true
objExcel.Workbo oks.Open (strLocation)
objExcel.UserCo ntrol = true
end sub
</script>
</head>

.....

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

</body>

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

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.WriteF ile
instead.

--
I hope this helps,
Steve C. Orr,
MCSD, MVP, CSM, ASPInsider
http://SteveOrr.net
"Looch" <lu**********@y ahoo.comwrote in message
news:11******** **************@ o5g2000hsb.goog legroups.com...

On Jun 4, 12:53 pm, "Steve C. Orr [MCSD, MVP, CSM, ASP Insider]"
<[e-mail] ote:

>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.WriteF ile, 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/lib...30(vs.71).aspx

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

"Looch" <lucianoj2...@y ahoo.comwrote in message

news:11******* **************@ h2g2000hsg.goog legroups.com...

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_machinena me) 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.- Hide quoted text -

- 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>Untitl ed Page</title>
<script language =vbscript >
dim objExcel
Sub cmdOrderFrm_onc lick()
call OpenWorkbook("C :Temp\test.xls" )
end sub

sub OpenWorkbook(st rLocation)
set objExcel = CreateObject("E xcel.Applicatio n")
objExcel.Visibl e = true
objExcel.Workbo oks.Open (strLocation)
objExcel.UserCo ntrol = true
end sub
</script>
</head>

....

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

</body>

[Mark Rae]

"Looch" <lu**********@y ahoo.comwrote in message
news:11******** *************@q 66g2000hsg.goog legroups.com...

>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.

Presumably, this Excel file is on the webserver somewhere...?
--
http://www.markrae.net

[Looch]

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).

>
--http://www.markrae.net