XLS to XML convertion

[macsql1]

Hi,

How to convert .xls file to XML. I have office 2003 and want to convert bookslog.xls file XML format, here bookslog.xls file contain 3 worksheets.

Thanks in advance.

mac

 

[Diancecht]

File > Save as > XML

Cheers,
Dian

 

[macsql1]

Hi Dian,

huh i was missing

well when i hit save as got following dialog box. Is there any way to export both the data and the VB code to XML? Thank again

======================================================================
The following features from your workbook will not be saved in the XML Spreadsheet:

.vb project

Do you want to continue saving as an XML Spreadsheet?
======================================================================


mac

 

[Diancecht]

You mean macros in the sheet? Why would you want to export that to an XML file?

XML is a data representation, maybe if you explain a little bit more what are you trying to do someone can offer you some ideas.

Cheers,
Dian

 

[fpmurphy]

No there is no way to export your macros to XML

 

[Diancecht]

There's always a way, depending on what you want to do.

Cheers,
Dian