for each ... Export to XLS

[#1]

I have a straight table object I can succesfully export to excel which meets most of my requirements, however the users frequently Filter this object to branch level, export to excel filter to next Branch Export etc.

How do I Automate this in a for each loop creating a Different Workbook for each Branch

ColinR

[#2 · Accepted solution]

Hi Colin, here is an example of a macro that iterates through a column generating different xls files based on each selection.

Hope this helps.

Regards.