View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Modify Macro Code Depending on Excel Version

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