Disable Auto Date Formatting for QueryTables.Add
 

I am using QueryTables.Add to query data from a MySQL database and drop it
into spreadsheets in Excel. The trouble is, that Excel likes to format
anything that looks like a date as a date, and in our case many things that
are not dates look like dates.

I need to programmatically disable Auto Formatting altogether before I run
these queries. Can anyone tell me how to do it?

Thanks.