View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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!