Isn't it the opening of the workbook after it's been populated where
the problem is?

What happens when you open it manually from within Excel?

One thing, as well as turning off screen updating and events might be
too set calculation to manual for the Excel application object.

I know the code doesn't involve formulas but it wouldn't do any harm
to try that.