[gamecockfan]

Does anyone know how to convert an Excel file to a XML file?

[OBP]

Anything wrong with the Save As version?

[gamecockfan]

I need the XML file in a certain format/schema. The 'Save As' does not allow me to do that format/schema.

[OBP]

I am not sure that the VBA version allows that either.
Have you looked at the SaveAs in the VBA Editor Help?
it show XML as a FileFormat in the expression
expression.SaveAs(FileName, FileFormat, Password, WriteResPassword, ReadOnlyRecommended, CreateBackup, AccessMode, ConflictResolution, AddToMru, TextCodepage, TextVisualLayout, Local)

[gamecockfan]

No, I have not looked at that. Would it help if I attached a file with the format I need?

[OBP]

Not for me as Excel is not my strong point and I have never used XML, you could post it and hope Zack, Bomb, Rollin or one of the other Excel regulars comes along.

[jimr381]

So you do not have an XSD file setup already? XSD are schema or structure files. Think of it as the shell of the database. XSL are the style of the output.

[gamecockfan]

Sounds good. Thanks for the suggestions.

[gamecockfan]

Yes, I do have a XSD file.

[jimr381]

Please check out the previous post.

[jimr381]

OK do you know how to attach the XSD file to the Excel file to get it it's structure to save as?

[jimr381]

OK check this out. Like most applications I know a little bit about it, slightly enough to be deadly with it. Go to "Data">>"XML">>"XML Source" from the menu bar. Click on the "XML" maps button and then click "Add." Switch the file type up to XSD files and it should load a map for you. Then basically you assign data from your spreadsheet to the map.

[gamecockfan]

Let me give it a go. Thanks.

[gamecockfan]

How do you assign the data to the map?

[gamecockfan]

I believe I have figured out how to assign the data. Thank you all for the help and suggestions.