| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How does one disable Auto-Formatting of dates? | Excel Discussion (Misc queries) | |||
| Disable auto-formatting dates.... GRRR! | Excel Discussion (Misc queries) | |||
| Disable auto-formatting dates.... GRRR! | Excel Worksheet Functions | |||
| Disable Excel's Auto Formatting | Excel Programming | |||
| Disable auto editor formatting | Excel Programming | |||
Threaded Mode
