Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert date from dbf files
I open a dbf file from vba and would like to convert all date to excel
format. Does it is possible to test the dbf column format (ex: Date 8.0) ? I have try this but doesn't work. Thanks! Dim Data As Date Set rng = wks.Rows(1).Find(DateValue(Data), LookAt:=xlWhole) If Not rng Is Nothing Then rng.EntireColumn.NumberFormat = "yyyy/mm/dd;@" Alex St-Pierre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert date from dbf files
Workbooks.Open "c:\data.dbf"
Does it exist a function that allow me to know what is the dbf format for a specific column ? with that, I will be able to ask each column. Or, does it have a function that keeps the dbf format when you open a dbf files ? Thank you. -- Alex St-Pierre "Alex St-Pierre" a écrit : I open a dbf file from vba and would like to convert all date to excel format. Does it is possible to test the dbf column format (ex: Date 8.0) ? I have try this but doesn't work. Thanks! Dim Data As Date Set rng = wks.Rows(1).Find(DateValue(Data), LookAt:=xlWhole) If Not rng Is Nothing Then rng.EntireColumn.NumberFormat = "yyyy/mm/dd;@" Alex St-Pierre |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I batch convert 97-2003 .xls files to 2007 .xlsx files | Excel Discussion (Misc queries) | |||
how do i convert text files into CSV files? | Excel Discussion (Misc queries) | |||
converter tool to convert XL 2007 files to XL 2003 files | Excel Discussion (Misc queries) | |||
Can I convert my Quatro Pro files to MS Excel files? | New Users to Excel | |||
convert 400 word files to excel files fast? | Excel Programming |