Setting the namespace when doing a SaveAsXMLData
Try checking you setting in DOS. I'm not sure if excel is one of the following
1) Excel Menu - Tools - Option - General - Default file Location
2) A mapped Netwrok drive
3) An environmental variable
START - Run - cmd.exe (Opens DOS window). The in DOS type SET. This
returns the environmental variables.
"jeffbanjo" wrote:
It seems that Excel picks
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance as the namespace when
saving mapped cells to a datafile. How do you set this to something
different or not have a xmlns attribute in the root at all?
Thanks!
|