Date:         Tue, 13 Dec 2011 11:34:54 -0500
Reply-To:     Subhadra Srigiriraju <subhadrasri@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Subhadra Srigiriraju <subhadrasri@GMAIL.COM>
Subject:      Re: XML code appears instead of opening an Excel file
Comments: To: Bolotin Yevgeniy <YBolotin@schools.nyc.gov>
In-Reply-To:  <01384B2401936142AF5F65E3D12402780B9F1FC0@EX3VS1.nyced.org>
Content-Type: text/plain; charset=ISO-8859-1

Thanks for the suggestions. I checked "File Types" and default program
associated with XML. We all have same types "XML Editor" associated with
it. Though they changed it to "Excel", it is not making any difference.

I created these files in XML and linked them via HTML report . A link is
proivded on the report, using "Title" Statment in SAS, which says "View in
Excel" and by clicking on which an Excel file is opened. This is an XML
file created by ExcelXP tagsets. If they save the file and open it using
Excel they can, but not directly by clicking on it. They were able to view
these files without any issues until last month.

As Joe suggested, i sent an email to SAS Support too regarding the same as
IT guys in my company couldn't figure out what the issue is.

Regards,
Subhadra

On Tue, Dec 13, 2011 at 9:41 AM, Bolotin Yevgeniy
<YBolotin@schools.nyc.gov>wrote:

> They see the underlying code in what? Notepad? Internet explorer? Excel?
> Something else?
>
> If the file opens in Excel but displays wrong content, then something is
> seriously wrong.
> If any other application opens, that just means that a new program was
> installed that overwrote the default handler for .xml files - you can
> check this by going, in Windows Explorer (on XP at least, if you have
> Windows 7 then search around for it)
>
> Tools -> Folder Options -> File Types tab -> find "XML" in the list ->
> click the Advanced button
>
> Make sure that whatever option opens the file with Excel is set as
> default
>
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Subhadra Srigiriraju
> Sent: Tuesday, December 13, 2011 6:38 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: XML code appears instead of opening an Excel file
>
> Joe,
>
> Thanks for the response. They are able to open regular Excel files
> (files
> created as Excel). But not XML files. A little excel icon does appear
> next
> to them, it means system recognized them as Excel files. But for some
> reason when the files are clicked they just see the underlying code.
>
> Thanks
> Subhadra
>
> On Mon, Dec 12, 2011 at 11:59 PM, Joe Matise <snoopy369@gmail.com>
> wrote:
>
> > Presumably their computers don't associate the files with Excel any
> > longer.  ODS ExcelXP tagset does produce XML files, though it's using
> > a format Excel knows how to read, and usually opens by default.  They
> > should be able to open them by opening Excel and then either opening
> > the files, or dragging them into the excel window.
> >
> > -Joe
> >
> > On Mon, Dec 12, 2011 at 8:19 PM, Subhadra Srigiriraju
> > <subhadrasri@gmail.com> wrote:
> > > Dear SAS users,
> > >
> > > I updated my SAS reports using ODS ExcelXP Tagsets. I'm able to open
> and
> > view
> > > these files on my computer without any issues. But my peers are not
> able
> > to
> > > view these files. When they click on the files, XML code appears.
> They
> > were
> > > able to view the files until last month. I checked with three and
> none
> > of them
> > > are able to view the files. I compared Excel versions on computers
> and
> > they
> > > are same. I'm really clueless on this.
> > >
> > > If you have any ideas to tackle this, you efforts would be greatly
> > > appreciated.
> > >
> > > Thanks
> > > Subhadra
> >
>