R
remain
I work with a website that accepts properly formatted XML documents to
do the transactions that I need to do everyday. I was trying to find a
way to make these XML documents in Excel because they are quite
extensive and all of the data that I use to make the documents is
stored in a bunch of Excel documents that I use to make calculations.
I tried making a small XML transaction in notepad and then opening it
up in Excel and excel opened it up nicely, but then I tried saving it
from excel as an XML document and it seriously screwed it up putting
all of my data in string tags and adding hundred of MS tags to the
document. Is there any way to get Excel to keep the original
formatting of the XML document? is there a way to keep it from
sticking the MS tags in there?
THanks, let me know if you need more information or examples.
do the transactions that I need to do everyday. I was trying to find a
way to make these XML documents in Excel because they are quite
extensive and all of the data that I use to make the documents is
stored in a bunch of Excel documents that I use to make calculations.
I tried making a small XML transaction in notepad and then opening it
up in Excel and excel opened it up nicely, but then I tried saving it
from excel as an XML document and it seriously screwed it up putting
all of my data in string tags and adding hundred of MS tags to the
document. Is there any way to get Excel to keep the original
formatting of the XML document? is there a way to keep it from
sticking the MS tags in there?
THanks, let me know if you need more information or examples.