Hi All

I'm trying to get far better control when creating Excel/VBA reporting of
SQL data.

I don't want the user messing with query, so I use the Macros/VBA part to
create the querying in the background. Only problem is that at present all
I can do with this is just retrieve one 'chunk' of data I don't seem to have
the flexibility like I can with ASP.

Can anybody give me pointers on how I can get the same versatility in Excel.

Thanks


Laphan