Exporting Sections to Excel

[suzreid]

I have a report that is split in to sections based on a location code.

I have a VB macro written that exports the complete results set to a single sheet in excel. I need to put each section on to a sheet of it's own.

Is this possible to do? I have tried using a filter on the report but when I export it, I still get the full results set.

Suz

 

[pabloj]

The built in html export function can export on different sheets (I think) if this is true you can reassemble it in a multi sheet excel file.

Stick to your guns

 

[Sridharan]

If you place a filter and then export then it should give you the correct result unless you are exporting from the DataProvider.

Sri