Please Help...Date converting to USA from UK when running Macro !!!

[padmaster]

Hi

Below is the code from a macro I am running in Excel.

The prolem is that once the file is saved the dates are converted into
USA format from UK format and this is causing major problems..

Would appreciate any help please...

Sub format()
'
' format Macro
' format for data load
'

'
ActiveWorkbook.Save
ActiveSheet.Unprotect
Rows("1:11").Select
Selection.Delete Shift:=xlUp
Columns("B:B").Select
Selection.ClearContents
ActiveWorkbook.SaveAs Filename:="c:\payroll\Cleaners.csv", _
FileFormat:=6, CreateBackup:=False
ActiveWorkbook.Close Savechanges:=False
End Sub



Thanks

Paddy

 

[raypayette]

Dates are recorded as a number; today is 38915! The presentation is a
question of format, either in Excel or Windows (Local settings).
By the way the code you have posted does not seem to directly involve
dates.

 

[padmaster]

Dates are recorded as a number; today is 38915! The presentation is a
question of format, either in Excel or Windows (Local settings).
By the way the code you have posted does not seem to directly involve
dates.

Sorry, the code is part of the macro....this macro is to convert an
excel file into a csv file and it is the dates within the files that
are being changed from a UK format to a USA one...

Any help is appreciated....
Paddy

 

[padmaster]

Sorry, the code is part of the macro....this macro is to convert a
excel file into a csv file and it is the dates within the files tha
are being changed from a UK format to a USA one...

Any help is appreciated....
Paddy

Sorted !!!

Range("c:c").NumberFormat = "dd/mm/yyyy"

Where c:c is the range

This ensures the format is correct in the macro...

Thanks for all your help