Can I reformat a worksheet column to a particular format?

In particular, my sheet is an export from another application and it's got the dates in a pickle ... the data in the columns show things like 37961, 38265, etc.,

I can select the whole column (in Excel) and change it to "date format", which shows the data correctly as 6/12/2003, 5/10/2004, etc. and it is this, that I need to do from within VB.

Regards,

Sean Anderson

__________________
Regards,

Sean Anderson

I recorded a macro in Excel, selected column A, right-clicked a cell, selected format cells, and set the format to Date. The resultant macro had the folowing code:     If you create a reference to Excel using CreateObject() or GetObject(), you should be able to use this action with the .ActiveWorkbook.

I used the following workround:

Range(oMySheet.Cells(2, nColumnNumber), oSheet.Cells(oSheet.Rows.Count, nColumnNumber)).NumberFormat = "dd/mm/yyyy"

I will have a look at using the "SELECT" within VB and see if I can do something clever there.

I can't get to a macro that's been recording in Excel, because it won't exist in the final version. The application is for a client who generates the spreadsheet from their system and then runs it through my application, you see.

Regards,

Sean Anderson

The reason I mentioned recording macros in Excel was not to keep them in Excel, but to have Excel reveal to you the way to do in code that which you did with the regular user interface, so that you can then adapt that way of doing things to your VB project.