Hi,
I'm currently working on a process where I am moving 3 separate collections (each collection is 6000 lines) into a single Excel workbook. I'm using the Excel VBO "Write Collection", however the process is takes around 5 minutes per collection to write to excel when I write to a new blank workbook. When I try write it to an existing workbook with data in different worksheets, it takes over an hour per collection to compile.
Is there a more efficient way of writing collections to excel?
Thanks,
Richard
