Bill,
We are storing the xml data from pivot lists and charts in group and
private folders as xml files.
We pass a file name (example: "\\My Documents\\OWCTest.xml") that the
user specifies to a function , open a text file and write the xml data
from the active pivot list on the page into the new text file. Any of
the user's xml files are listed in a select object on the web page and
anytime he/she selects one we load the owc with the xml data and allow
them to save any changes they may make. Sample javascript below for
saving xml data.
// Function to save xml data from an active owc.
// Pass a file name to the function.
function SaveXML(xmlFile){
//Save the file.
try
{
// Create a file scripting object.
var fso = new
ActiveXObject("Scripting.FileSystemObject");
// Open a text file.
var a = fso.CreateTextFile(xmlFile, true);
// Get the xml data from the active owc.
a.Write(ptFunc.XMLData);
//Close the text file.
a.Close();
//successful save.
return(true);
}
catch(e)
{
return(false);
}
}
The xmlData feature works for PivotLists, Charts, and Spreadsheets.
The OWC VBA10 help files should also help, keyword "xmlData".
William_k
