Hello!
We thinked about it. May it is our target.
But still have no idea, how to allow user to modify template without calling
a programmer.
Boris


--------------
"Bob Phillips" wrote in message
...
XSLT?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Boris Glazyrin" <bglazyr(c)fors.ru wrote in message
...
Hello!

Thank You for Your answer.

Is it possible to customize it? Our report is quite complex.

Here is simple example

----

FooBar001 name

FooBar001 address

Charles name, Charles tel

Charles comment

John name, John tel

john comment

HeyFoo name

HeyFoo address

----

Our main target is to give user ability to customize Excel template and
load
structural data into it.

Now we use our own vba program, that load data into template. But may be
we
can simplify our program (or even throw away :) ) using new XML
capabilities
of Excel? We are using Excel 2000 features currently. May be even 97.



Thank You in advance

Boris


"Francesco Sblendorio" wrote in message
...
Yes, it's possible: the master-detail structure is flattened.
Example: this XML ...

<people
<department
<idFooBar001</id
<employee
<nameCharles</name
<age27</age
</employee
<employee
<nameJohn</name
<age21</age
</employee
</department
<department
<idHeyFoo002</id
<employee
<nameMichel</name
<age29</age
</employee
<employee
<nameHerbert</name
<age32</age
</employee
</department

is rendered like this:
ID NAME AGE
--------- -------- ---
FooBar001 Charles 27
FooBar001 John 21
HeyFoo002 Michael 29
HeyFoo002 Herbert 32