Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The KB article is 911750 and it states there is a hotfix available from
Microsoft. Why not use it? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "John Taylor" wrote in message Dave, I need the extra code (ie., Local:=True) in xl2003 because there is a known bug (KB 911759) which causes dd/mm/yyyy dates imported from a csv file, using VBA, to be imported in the incorrect format. A possibility is to run two separate workbooks, one for xl97 and one for xl2003, but that isn't really very satisfactory. Hence my attempt to have the code written so that it will run correctly in any version. Regards, John |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Jim,
You're correct, of course; it is 911750 - sorry for the typo. I will try it (the hotfix) when I get it; I've contacted MS Support and they are going to send it to me. The only problem, and I'll face it when I get the hotfix, is that the hotfix files are older than my current - updated with security fixes, etc. - version of Excel, so I will have to track down the security patches that have been issued since the hotfix and then install it/them. Regards, John "Jim Cone" wrote in message ... The KB article is 911750 and it states there is a hotfix available from Microsoft. Why not use it? -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "John Taylor" wrote in message Dave, I need the extra code (ie., Local:=True) in xl2003 because there is a known bug (KB 911759) which causes dd/mm/yyyy dates imported from a csv file, using VBA, to be imported in the incorrect format. A possibility is to run two separate workbooks, one for xl97 and one for xl2003, but that isn't really very satisfactory. Hence my attempt to have the code written so that it will run correctly in any version. Regards, John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify a Macro | Excel Worksheet Functions | |||
Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
How to modify a copy macro | Excel Worksheet Functions | |||
Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
How do I modify a row depending upon what a cell value is? | Excel Worksheet Functions |