Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting hijri date to gregorian date | Excel Discussion (Misc queries) | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
Converting a year date into a specific day date | Charts and Charting in Excel | |||
converting date from a textbox to a date format | Excel Programming | |||
Converting a string date into a Excel Date | Excel Programming |