tactps
01-05-2005, 09:00 PM
I am having a problem with csv files which I am saving via VBA.
The format of my dates in the Excel spreadsheet is dd/mm/yyyy. It appears that when users have their short date in the regional settings set as "dd/mm/yy" this overwrites my macro when the csv is saved.
Is there a way to overwrite the regional settings, or at least examine them in VBA so that I can have the macro stop if these settings are incorrect?
Alternatively, is there a way to force the csv to pick up the correct format?
The format of my dates in the Excel spreadsheet is dd/mm/yyyy. It appears that when users have their short date in the regional settings set as "dd/mm/yy" this overwrites my macro when the csv is saved.
Is there a way to overwrite the regional settings, or at least examine them in VBA so that I can have the macro stop if these settings are incorrect?
Alternatively, is there a way to force the csv to pick up the correct format?