Disable Auto Date Formatting for QueryTables.Add

L

Lazzaroni

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cobditional Formatting Rows based on dates in action plan. 0
Permanently Disable Auto Formatting of Cell Content 3
conditional formatting suddenly disabled 1
Querytables.add with sql query text stored in separate text file 5
howto: disable date recognition? 0
UserForm ComboBox Date Format 1
How to Auto populate dates from a given start date 2
Get Date from one cell to format another, then... 6

Top