export to excel

[Andre]

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.Conten tType = "applicatio n/vnd.ms-excel"
Response.Charse t = ""
EnableViewState = false

Thanks, Andre

[Manohar Kamath]

Re: export to excel

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

https://www.dotnetwire.com

"Andre" <no@spam.com> wrote in message
news:ez%23ezo6r EHA.2136@TK2MSF TNGP14.phx.gbl. ..[color=blue]
> 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[/color]
of[color=blue]
> 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,[/color]
it's[color=blue]
> all I need. Does anyone have any suggestions for what might be causing[/color]
this[color=blue]
> 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.Conten tType = "applicatio n/vnd.ms-excel"
> Response.Charse t = ""
> EnableViewState = false
>
> Thanks, Andre
>
>[/color]

[Andre]

Re: export to excel

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.as p 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" <mkamath@TAKETH ISOUTkamath.com > wrote in message
news:%23RtPer6r EHA.3876@TK2MSF TNGP15.phx.gbl. ..[color=blue]
> 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" <no@spam.com> wrote in message
> news:ez%23ezo6r EHA.2136@TK2MSF TNGP14.phx.gbl. ..[color=green]
> > 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[/color]
> of[color=green]
> > 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[/color][/color]
working[color=blue][color=green]
> > for them.
> >
> > This is the code that I use, and from what I find around the Internet,[/color]
> it's[color=green]
> > all I need. Does anyone have any suggestions for what might be causing[/color]
> this[color=green]
> > 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.Conten tType = "applicatio n/vnd.ms-excel"
> > Response.Charse t = ""
> > EnableViewState = false
> >
> > Thanks, Andre
> >
> >[/color]
>
>[/color]

[Mark Schupp]

Re: export to excel

see if this helps:

http://groups.google.com/groups?hl=en&lr=&selm=%23LLFmCWRDHA.2148%40TK2MSFTNGP11.phx.gbl

--
Mark Schupp
Head of Development
Integrity eLearning

https://www.ielearning.com

"Andre" <no@spam.com> wrote in message
news:%23t%23b$J 7rEHA.1152@TK2M SFTNGP11.phx.gb l...[color=blue]
> They get 1 of 2 different dialog boxes.
>
> - One says "Microsoft Office Excel cannot access the file 'my url[/color]
here...'.[color=blue]
> 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.as p from 'my url...'.[/color]
IE[color=blue]
> 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" <mkamath@TAKETH ISOUTkamath.com > wrote in message
> news:%23RtPer6r EHA.3876@TK2MSF TNGP15.phx.gbl. ..[color=green]
> > What is "not working for them" mean? Do they get a file prompt at least?[/color][/color]
I[color=blue][color=green]
> > have several reports in the similar way, but I haven't seen any[/color][/color]
difference[color=blue][color=green]
> > upgrading to Office 2003.
> >
> > --
> > Manohar Kamath
> > Editor, .netWire
> > www.dotnetwire.com
> >
> >
> > "Andre" <no@spam.com> wrote in message
> > news:ez%23ezo6r EHA.2136@TK2MSF TNGP14.phx.gbl. ..[color=darkred]
> > > I'm not sure if this is the best place for this post or not, but I[/color][/color][/color]
can't[color=blue][color=green][color=darkred]
> > > find many asp newsgroups anymore.
> > >
> > > I have an app that's 3-4 years old, and has been working just fine.[/color][/color][/color]
One[color=blue][color=green]
> > of[color=darkred]
> > > 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[/color][/color]
> working[color=green][color=darkred]
> > > for them.
> > >
> > > This is the code that I use, and from what I find around the Internet,[/color]
> > it's[color=darkred]
> > > all I need. Does anyone have any suggestions for what might be[/color][/color][/color]
causing[color=blue][color=green]
> > this[color=darkred]
> > > to not work in Office XP/2003? It still works just fine on Office[/color][/color][/color]
2000.[color=blue][color=green][color=darkred]
> > > Could it be a security setting in the newer version of Office?
> > >
> > > Response.Buffer = True
> > > Response.Conten tType = "applicatio n/vnd.ms-excel"
> > > Response.Charse t = ""
> > > EnableViewState = false
> > >
> > > Thanks, Andre
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]

[Andre]

Re: export to excel

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" <mschupp@ielear ning.com> wrote in message
news:ePREeW7rEH A.3520@TK2MSFTN GP11.phx.gbl...[color=blue]
> see if this helps:
>[/color]
http://groups.google.com/groups?hl=e...TNGP11.phx.gbl[color=blue]
>
> --
> Mark Schupp
> Head of Development
> Integrity eLearning
> www.ielearning.com
>
>
> "Andre" <no@spam.com> wrote in message
> news:%23t%23b$J 7rEHA.1152@TK2M SFTNGP11.phx.gb l...[color=green]
> > They get 1 of 2 different dialog boxes.
> >
> > - One says "Microsoft Office Excel cannot access the file 'my url[/color]
> here...'.[color=green]
> > 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[/color][/color]
currently[color=blue][color=green]
> > open workbook.
> >
> > - The other says "IE cannot download excel_report.as p from 'my url...'.[/color]
> IE[color=green]
> > 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" <mkamath@TAKETH ISOUTkamath.com > wrote in message
> > news:%23RtPer6r EHA.3876@TK2MSF TNGP15.phx.gbl. ..[color=darkred]
> > > What is "not working for them" mean? Do they get a file prompt at[/color][/color][/color]
least?[color=blue]
> I[color=green][color=darkred]
> > > have several reports in the similar way, but I haven't seen any[/color][/color]
> difference[color=green][color=darkred]
> > > upgrading to Office 2003.
> > >
> > > --
> > > Manohar Kamath
> > > Editor, .netWire
> > > www.dotnetwire.com
> > >
> > >
> > > "Andre" <no@spam.com> wrote in message
> > > news:ez%23ezo6r EHA.2136@TK2MSF TNGP14.phx.gbl. ..
> > > > I'm not sure if this is the best place for this post or not, but I[/color][/color]
> can't[color=green][color=darkred]
> > > > find many asp newsgroups anymore.
> > > >
> > > > I have an app that's 3-4 years old, and has been working just fine.[/color][/color]
> One[color=green][color=darkred]
> > > 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[/color]
> > working[color=darkred]
> > > > for them.
> > > >
> > > > This is the code that I use, and from what I find around the[/color][/color][/color]
Internet,[color=blue][color=green][color=darkred]
> > > it's
> > > > all I need. Does anyone have any suggestions for what might be[/color][/color]
> causing[color=green][color=darkred]
> > > this
> > > > to not work in Office XP/2003? It still works just fine on Office[/color][/color]
> 2000.[color=green][color=darkred]
> > > > Could it be a security setting in the newer version of Office?
> > > >
> > > > Response.Buffer = True
> > > > Response.Conten tType = "applicatio n/vnd.ms-excel"
> > > > Response.Charse t = ""
> > > > EnableViewState = false
> > > >
> > > > Thanks, Andre
> > > >
> > > >
> > >
> > >[/color]
> >
> >[/color]
>
>[/color]