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

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

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

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.


--
raypayette


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

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

raypayette Wrote:
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
------------------------------------------------------------------------
padmaster's Profile: http://www.excelforum.com/member.php...o&userid=36433
View this thread: http://www.excelforum.com/showthread...hreadid=561993

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

padmaster Wrote:
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

--
padmaste
-----------------------------------------------------------------------
padmaster's Profile: http://www.excelforum.com/member.php...fo&userid=3643
View this thread: http://www.excelforum.com/showthread.php?threadid=56199