Loop through active columns and save to file

[elmnas]

Hi guys,

I need a script that loop through each active column,
and each column as xls with the filename from the open document + the name of the first cell in the same column

[Yongle]

I think this has been answered by snb at end of thread called "how to loop through all used cells in just row 1 and alert?" (thread started by elmnas)