Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Saving as XML
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 <TimeCardNo1</TimeCardNo <EmployeeNameAA</EmployeeName .... </TimeCard </TimeCards But, when I save the sheet, the resulting file has: "<?xml version=""1.0"" ?" "<TimeCards Version=""2.3""" <TimeCard <TimeCardNo1</TimeCardNo <EmployeeNameAA</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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
VBA not saving! | Excel Discussion (Misc queries) | |||
Saving xls to pdf | Excel Discussion (Misc queries) | |||
saving pdf | Excel Discussion (Misc queries) | |||
Saving | Excel Discussion (Misc queries) |