Thank you David J

It seems we are thinking at the same direction.

You can do it in VBA and VB script. In fact some time I development and tests

in VBA (testing and editing macros) and then translate the result to VB script. But so far

we have been talking about formating. If you need more complicated actions depending

on actual data like subsums filtering linking to other sheets etc I stay with ADO and VBA because it works. And it is really fashinating what you can do with Excel. I have for a client made a "customer simulator". This workbook is loaded with 6 different queries (in different sheets) from the data ware house and there is a lot of logic inside. A salesman can key in a prospect and simulate different situations to calculate the assumed net margin.

🙂 Gosta