Thread: XML Data Island in Excel Workbook?

My current challenge requires me to keep some xml data with the Excel
workbooks created for my application. This way, the workbooks can exist by
themselves and be e-mailed around without losing functionality.

My big question is: What is the best way to keep XML data with an Excel
Workbook for future use? The concept would be similar to an XML data island
in an HTML page. Some ideas I've kicked around are storing it as plain text
in a hidden sheet, or embedding an XML file object somewhere.

I need to be able to read and write to the xml data. The kicker is that I
also need to support Office 2k and higher.

Suggestions are more than appreciated, thanks in advance.

Todd Larson

How much XML ?

--
Tim Williams
Palo Alto, CA


"Todd Larson" <ToddLarson@discussions.microsoft.com> wrote in message
news:103673B9-7FF9-4266-B521-69ECDF587C90@microsoft.com...
> My current challenge requires me to keep some xml data with the Excel
> workbooks created for my application. This way, the workbooks can exist
by
> themselves and be e-mailed around without losing functionality.
>
> My big question is: What is the best way to keep XML data with an Excel
> Workbook for future use? The concept would be similar to an XML data
island
> in an HTML page. Some ideas I've kicked around are storing it as plain
text
> in a hidden sheet, or embedding an XML file object somewhere.
>
> I need to be able to read and write to the xml data. The kicker is that I
> also need to support Office 2k and higher.
>
> Suggestions are more than appreciated, thanks in advance.
>
> Todd Larson

I'm not exactly sure how much, since the app is still in design phase. It
could be in the 100KB to 300KB range.

Todd Larson

"Tim Williams" wrote:

> How much XML ?
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "Todd Larson" <ToddLarson@discussions.microsoft.com> wrote in message
> news:103673B9-7FF9-4266-B521-69ECDF587C90@microsoft.com...
> > My current challenge requires me to keep some xml data with the Excel
> > workbooks created for my application. This way, the workbooks can exist
> by
> > themselves and be e-mailed around without losing functionality.
> >
> > My big question is: What is the best way to keep XML data with an Excel
> > Workbook for future use? The concept would be similar to an XML data
> island
> > in an HTML page. Some ideas I've kicked around are storing it as plain
> text
> > in a hidden sheet, or embedding an XML file object somewhere.
> >
> > I need to be able to read and write to the xml data. The kicker is that I
> > also need to support Office 2k and higher.
> >
> > Suggestions are more than appreciated, thanks in advance.
> >
> > Todd Larson
>
>
>