troubles with Excel

S

shank

Having problems with below. I have a page that generates Excel sheets.

If I comment out the next line, data displays on screen as expected.
<% Response.contenttype = "application/vnd.ms-excel" %>

Uncomment the above line and insert this line, it opens Excel as expected
<% On Error Resume Next %>

Remove "On Error..." and Uncomment the above line, I get an error the "Page
Cannot Be Found". Also, in the message box, the expected filename is
displayed as stuff_asp instead of stuff.asp.

What's wrong? How do I troubleshoot between code or data? Would something in
the data have an influence on this line? <% Response.contenttype =
"application/vnd.ms-excel" %>

I would assume the page would at least begin to load and if there was data
issues, it would fault at that spot.

thanks!
 
B

Bob Barrows

shank said:
Having problems with below. I have a page that generates Excel sheets.

If I comment out the next line, data displays on screen as expected.
<% Response.contenttype = "application/vnd.ms-excel" %>

Uncomment the above line and insert this line, it opens Excel as
expected <% On Error Resume Next %>

With the correct data shown in Excel?
Remove "On Error..." and Uncomment the above line, I get an error the
"Page Cannot Be Found". Also, in the message box, the expected
filename is displayed as stuff_asp instead of stuff.asp.

What's wrong? How do I troubleshoot between code or data? Would
something in the data have an influence on this line? <%
Response.contenttype = "application/vnd.ms-excel" %>

Obviously, that is not the line that is causing the problem.
I would assume the page would at least begin to load and if there was
data issues, it would fault at that spot.
I would suspect the line that assigns the name of the xls file, which you
haven't shown us.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,794
Messages
2,569,641
Members
45,355
Latest member
SJLChristi

Latest Threads

Top