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


--
padmaster
------------------------------------------------------------------------
padmaster's Profile: http://www.excelforum.com/member.php...o&userid=36433
View this thread: http://www.excelforum.com/showthread...hreadid=561993