«

I'm not sure if this is the best place for this post or not, but I can't
find many asp newsgroups anymore.

I have an app that's 3-4 years old, and has been working just fine. One of
the pages exports the html to Excel. My users just upgraded from
Office97/2000 to Office XP/2003, and now the export to Excel isn't working
for them.

This is the code that I use, and from what I find around the Internet, it's
all I need. Does anyone have any suggestions for what might be causing this
to not work in Office XP/2003? It still works just fine on Office 2000.
Could it be a security setting in the newer version of Office?

Response.Buffer = True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
EnableViewState = false

Thanks, Andre

What is "not working for them" mean? Do they get a file prompt at least? I
have several reports in the similar way, but I haven't seen any difference
upgrading to Office 2003.

--
Manohar Kamath
Editor, .netWire
www.dotnetwire.com


"Andre" <> wrote in message
news:ez%...
> I'm not sure if this is the best place for this post or not, but I can't
> find many asp newsgroups anymore.
>
> I have an app that's 3-4 years old, and has been working just fine. One
of
> the pages exports the html to Excel. My users just upgraded from
> Office97/2000 to Office XP/2003, and now the export to Excel isn't working
> for them.
>
> This is the code that I use, and from what I find around the Internet,
it's
> all I need. Does anyone have any suggestions for what might be causing
this
> to not work in Office XP/2003? It still works just fine on Office 2000.
> Could it be a security setting in the newer version of Office?
>
> Response.Buffer = True
> Response.ContentType = "application/vnd.ms-excel"
> Response.Charset = ""
> EnableViewState = false
>
> Thanks, Andre
>
>

They get 1 of 2 different dialog boxes.

- One says "Microsoft Office Excel cannot access the file 'my url here...'.
There are several possible reasons:
- The file name or path does not exist.
- The file is being used by another program.
- The workbook you are trying to save has the same name as a currently
open workbook.

- The other says "IE cannot download excel_report.asp from 'my url...'. IE
was not able to open the Internet site. The requested site is either
unavailable or cannot be found. Please try again later.

Does this tell you anything?

Andre


"Manohar Kamath" <> wrote in message
news:%...
> What is "not working for them" mean? Do they get a file prompt at least? I
> have several reports in the similar way, but I haven't seen any difference
> upgrading to Office 2003.
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com
>
>
> "Andre" <> wrote in message
> news:ez%...
> > I'm not sure if this is the best place for this post or not, but I can't
> > find many asp newsgroups anymore.
> >
> > I have an app that's 3-4 years old, and has been working just fine. One
> of
> > the pages exports the html to Excel. My users just upgraded from
> > Office97/2000 to Office XP/2003, and now the export to Excel isn't
working
> > for them.
> >
> > This is the code that I use, and from what I find around the Internet,
> it's
> > all I need. Does anyone have any suggestions for what might be causing
> this
> > to not work in Office XP/2003? It still works just fine on Office 2000.
> > Could it be a security setting in the newer version of Office?
> >
> > Response.Buffer = True
> > Response.ContentType = "application/vnd.ms-excel"
> > Response.Charset = ""
> > EnableViewState = false
> >
> > Thanks, Andre
> >
> >
>
>

see if this helps:
http://groups.google.com/groups?hl=e...TNGP11.phx.gbl

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com


"Andre" <> wrote in message
news:%23t%23b$...
> They get 1 of 2 different dialog boxes.
>
> - One says "Microsoft Office Excel cannot access the file 'my url
here...'.
> There are several possible reasons:
> - The file name or path does not exist.
> - The file is being used by another program.
> - The workbook you are trying to save has the same name as a currently
> open workbook.
>
> - The other says "IE cannot download excel_report.asp from 'my url...'.
IE
> was not able to open the Internet site. The requested site is either
> unavailable or cannot be found. Please try again later.
>
> Does this tell you anything?
>
> Andre
>
>
> "Manohar Kamath" <> wrote in message
> news:%...
> > What is "not working for them" mean? Do they get a file prompt at least?
I
> > have several reports in the similar way, but I haven't seen any
difference
> > upgrading to Office 2003.
> >
> > --
> > Manohar Kamath
> > Editor, .netWire
> > www.dotnetwire.com
> >
> >
> > "Andre" <> wrote in message
> > news:ez%...
> > > I'm not sure if this is the best place for this post or not, but I
can't
> > > find many asp newsgroups anymore.
> > >
> > > I have an app that's 3-4 years old, and has been working just fine.
One
> > of
> > > the pages exports the html to Excel. My users just upgraded from
> > > Office97/2000 to Office XP/2003, and now the export to Excel isn't
> working
> > > for them.
> > >
> > > This is the code that I use, and from what I find around the Internet,
> > it's
> > > all I need. Does anyone have any suggestions for what might be
causing
> > this
> > > to not work in Office XP/2003? It still works just fine on Office
2000.
> > > Could it be a security setting in the newer version of Office?
> > >
> > > Response.Buffer = True
> > > Response.ContentType = "application/vnd.ms-excel"
> > > Response.Charset = ""
> > > EnableViewState = false
> > >
> > > Thanks, Andre
> > >
> > >
> >
> >
>
>

Unfortunately, it didn't. I removed the "cache" instances from the code and
the export still works great for me on Office 2k. My user on XP still isn't
able to get it to work. She's also telling me that if she exports just a
few thousand records, it will work. But the one we're working on now is 12k
records. Like I said, it works great still on a desktop with Office 2k.

Any other suggestions are much appreciated.

Thanks, Andre


"Mark Schupp" <> wrote in message
news:...
> see if this helps:
>
http://groups.google.com/groups?hl=e...TNGP11.phx.gbl
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>
> "Andre" <> wrote in message
> news:%23t%23b$...
> > They get 1 of 2 different dialog boxes.
> >
> > - One says "Microsoft Office Excel cannot access the file 'my url
> here...'.
> > There are several possible reasons:
> > - The file name or path does not exist.
> > - The file is being used by another program.
> > - The workbook you are trying to save has the same name as a
currently
> > open workbook.
> >
> > - The other says "IE cannot download excel_report.asp from 'my url...'.
> IE
> > was not able to open the Internet site. The requested site is either
> > unavailable or cannot be found. Please try again later.
> >
> > Does this tell you anything?
> >
> > Andre
> >
> >
> > "Manohar Kamath" <> wrote in message
> > news:%...
> > > What is "not working for them" mean? Do they get a file prompt at
least?
> I
> > > have several reports in the similar way, but I haven't seen any
> difference
> > > upgrading to Office 2003.
> > >
> > > --
> > > Manohar Kamath
> > > Editor, .netWire
> > > www.dotnetwire.com
> > >
> > >
> > > "Andre" <> wrote in message
> > > news:ez%...
> > > > I'm not sure if this is the best place for this post or not, but I
> can't
> > > > find many asp newsgroups anymore.
> > > >
> > > > I have an app that's 3-4 years old, and has been working just fine.
> One
> > > of
> > > > the pages exports the html to Excel. My users just upgraded from
> > > > Office97/2000 to Office XP/2003, and now the export to Excel isn't
> > working
> > > > for them.
> > > >
> > > > This is the code that I use, and from what I find around the
Internet,
> > > it's
> > > > all I need. Does anyone have any suggestions for what might be
> causing
> > > this
> > > > to not work in Office XP/2003? It still works just fine on Office
> 2000.
> > > > Could it be a security setting in the newer version of Office?
> > > >
> > > > Response.Buffer = True
> > > > Response.ContentType = "application/vnd.ms-excel"
> > > > Response.Charset = ""
> > > > EnableViewState = false
> > > >
> > > > Thanks, Andre
> > > >
> > > >
> > >
> > >
> >
> >
>
>