| 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 |
| 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 | |||
Threaded Mode
