XML Advantages in Excell

P

Piotr

Hi,
I have hard about great XML futures in Excel, but I cant find any
examples how to use and what are the advantages, could anyone give me
some good link or some info about how could I improve my day to day
task with use of XML ?

regards
Peter
 
H

Harlan Grove

Piotr wrote...
I have hard about great XML futures in Excel, but I cant find any
examples how to use and what are the advantages, could anyone give me
some good link or some info about how could I improve my day to day
task with use of XML ?
Click to expand...

If you don't already have some notion of how XML would benefit you,
it's very likely it wouldn't. XML would be most useful if you were
trying to use data contained in Excel workbooks in other applications.
If you only use data contained in Excel workbooks in Excel itself, then
there's very little benefit to XML.
 
P

Piotr

Would be possible to make a excell conection to exported data from
Access in XML ?
And then export changed by user table to XML as automatic ?
 
T

Tushar Mehta

Conceptually, and at its simplest level, XML is another way of storing data
-- very much like a CSV file for example. Two big "things" about XML are
that (1) everything is in a human-readable text format (very much like HTML
is human readable and creates web pages) and (2) one can describe the layout
of the data within the file itself where the description can be fairly
complex. This, of course, allows the data in the file to be fairly complex
itself.

You really should start with an introductory book (or website?) on the
subject.

I use XML to transfer data from a web-driven database to XL. For several
applications I've developed, whenever the user wants to get the data from
the database, s/he visits this web page and requests the data. The request
is processed by a ASP page that writes the data to a text file using the
same rules as XL's SpreadsheetXML format. Once done, the user can download
the XML file to their machine and open it with XL.

If you are interested in further processing...I developed an add-in that (1)
saves the XML file as a regular XL file and (2) creates a new workbook based
on a template that I provide. This new workbook contains several results
(pivottables, non-pivottables, charts, etc.) needed to analyze the
downloaded data. It accesses the downloaded data (now in a regular XL file)
via a SQL query (created through MS Query).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Top