View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lazzaroni Lazzaroni is offline
external usenet poster
 
Posts: 55
Default 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.