Comments by debbie61 (Top 1 by date)

In respect to Damian's post that if the file is creating properly(and you can open it directly from Excel)....
That is not correct. I have run the same code over a spreadsheet multiple times and had it fail for External table format error and then magically it works.