Date:         Tue, 13 Dec 2011 14:21:04 -0700
Reply-To:     Alan Churchill <alan.churchill@PROGNOSINC.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Alan Churchill <alan.churchill@PROGNOSINC.COM>
Subject:      Re: XML code appears instead of opening an Excel file
Content-Type: text/plain; charset="us-ascii"

Subhadra,

I have not followed every message so bear with me if you have tried this.

Open Windows Explorer, right-click on the file, Open With, Choose default
program (at bottom), browse to c:\program files (x86)\ Microsoft
Office\Office 14\ excel.exe.( Approximately. YMMV depending upon your O/S,
office version, etc.).

That should do it.

Thanks,
Alan

Alan Churchill
Director of IT, Prognos Inc.
719-687-5954 (Work)
719-310-4870 (Cell)

-----Original Message-----
From: Subhadra Srigiriraju [mailto:subhadrasri@GMAIL.COM]
Sent: Tuesday, December 13, 2011 9:35 AM
Subject: Re: XML code appears instead of opening an Excel file

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