Saving as XML

G

Gavin Bird

Hi, Building a vba module that exports timecard data from XL to a
payroll system using an XML import format. Everything is OK except
when the created file is saved as XML or TXT or CSV or whatever; i've
tried a lot of them.

The XML has been tested as OK and the export worksheet shows (in
column A):
<?xml version="1.0" ?>
<TimeCards Version="2.3">
<TimeCard>
<TimeCardNo>1</TimeCardNo>
<EmployeeName>AA</EmployeeName>
....
</TimeCard>
</TimeCards>

But, when I save the sheet, the resulting file has:
"<?xml version=""1.0"" ?>"
"<TimeCards Version=""2.3"">"
<TimeCard>
<TimeCardNo>1</TimeCardNo>
<EmployeeName>AA</EmployeeName>
....
</TimeCard>
</TimeCards>

The additional quotes on the top two lines causing the import file to
be "not recognized" as being in an XML format. I have tried multiple
XL formats to save the file as but only manually removing the
additional quotes allows the file to be imported. Any ideas will
help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save as word to xml is splitting place holders ex: $abc.xyz$ 0
Excel found unreadable content in file error. 0
Excel 2010 - Save as XML 0
Save as XML 0
Open EXCEL.exe in Background using a .BAT File 0
Excel IMPORT which updates fields 0
Exporting / Saving as XML 3
Can Excel 2002 XML Spreadsheet format be read by Excel 2007? 1

Top