I've been sent an .xls file from a supplier, but when I open it in XL
2000 this is what I see:

<?xml version='1.0'?
<?mso-application progid='Excel.Sheet'?
<s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-
microsoft-com:office:spreadsheet"
<o:DocumentProperties
<o:AuthorBill Production System</o:Author
<o:Created2008-02-08T10:51:38</o:Created
<o:LastSaved2007-02-01T13:14:36</o:LastSaved

This is just the first few rows - it goes on for 23,000+, and all
these entries are in column A.

The supplier has had a new billing system installed.

Can I do anything with this file?

Pete

Looks like it's part of an Excel 2007 file. Excel 2007 creates XML files and
stores them as compressed files. You can rename an Excel 2007 .xlsx file as
..zip and open the file with WinZip or any unzipper and look at the files
inside in a text editor.

Tyro

"Pete_UK" wrote in message
...
I've been sent an .xls file from a supplier, but when I open it in XL
2000 this is what I see:

<?xml version='1.0'?
<?mso-application progid='Excel.Sheet'?
<s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-
microsoft-com:office:spreadsheet"
<o:DocumentProperties
<o:AuthorBill Production System</o:Author
<o:Created2008-02-08T10:51:38</o:Created
<o:LastSaved2007-02-01T13:14:36</o:LastSaved

This is just the first few rows - it goes on for 23,000+, and all
these entries are in column A.

The supplier has had a new billing system installed.

Can I do anything with this file?

Pete

Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete

On Mar 5, 5:30Â*pm, "Tyro" wrote:
Looks like it's part of an Excel 2007 file. Excel 2007 creates XML files and
stores them as compressed files. You can rename an Excel 2007 .xlsx file as
.zip and open the file with WinZip or any unzipper and look at the files
inside in a text editor.

Tyro

"Pete_UK" wrote in message

...
I've been sent an .xls file from a supplier, but when I open it in XL
2000 this is what I see:

<?xml version='1.0'?
<?mso-application progid='Excel.Sheet'?
<s:Workbook xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:s="urn:schemas-
microsoft-com:office:spreadsheet"
Â* <o:DocumentProperties
Â* Â* <o:AuthorBill Production System</o:Author
Â* Â* <o:Created2008-02-08T10:51:38</o:Created
Â* Â* <o:LastSaved2007-02-01T13:14:36</o:LastSaved

This is just the first few rows - it goes on for 23,000+, and all
these entries are in column A.

The supplier has had a new billing system installed.

Can I do anything with this file?

Pete

Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:
Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete

I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:



Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -

Excel 2007 can import/export XML files on the Developer Tab of the ribbon.
It can also save files as XML Data or Excel 2003 XML. I just saved a
workbook in Excel 2003 XML format, closed it and opened it in XML format
with no problem. Perhaps you could open your file in Excel 2003/2007 in XML
format and save it in xls format.

Tyro

"Pete_UK" wrote in message
...
I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35 pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30 pm, Pete_UK wrote:



Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -

You need at least 2003 version to deal with XML


Gord

On Wed, 5 Mar 2008 12:56:59 -0800 (PST), Pete_UK wrote:

I renamed it to .xml but File | Open just saw it as a text file and
took me into the Text Import Wizard. I think it was later versions of
XL that could import xml files directly, but thanks for the
suggestion.

Any other ideas?

Pete

On Mar 5, 7:35*pm, JP wrote:
Can you rename the file to .xml and try to import?

--JP

On Mar 5, 2:30*pm, Pete_UK wrote:



Thanks for the suggestion, Tyro, but unfortunately it didn't work -
maybe because it was an .xls file and not .xlsx. I downloaded the
XL2007 viewer/converter last week to try that, but no joy there
either.

Anyone else with any ideas on what I can do to open this file
normally? (I have requested the supplier to sort it out, but they
don't seem too interested or capable of doing so).

Pete- Hide quoted text -

- Show quoted text -