Hi,
If you are using 2013 or later then either use default Save as Excel function after creating a layout or try to use Excel buffer table. You can find it in some standard reports which uses Excel Buffer table for Print to excel.It would be faster than automation.
If you are using 2009 or previous also you can try using Excel buffer table, I think it should work faster than automations.