Set Cell format using VB.NET - Hug

14-Feb-08 12:07:04
Hi,

I want to open a exsiting CSV file and set the Data Format of column A (Date
and time) to Date (m/d/yyyy) and column width to certain number. I can open
the file but how to set the format? Thanks very much.

My code:

Dim excel As Microsoft.Office.Interop.Excel.Application
Dim wb As Microsoft.Office.Interop.Excel.Workbook
excel = New Microsoft.Office.Interop.Excel.Application
wb = excel.Workbooks.Open(FileName)
excel.Visible = True
wb.Activate()
reply
Set Cell format using VB.NET - Hug 14-Feb-08
        RE: Set Cell format using VB.NET - HelpFrom 14-Feb-08
                RE: Set Cell format using VB.NET - Hug 14-Feb-08
                        RE: Set Cell format using VB.NET - HelpFrom 14-Feb-08
                                RE: Set Cell format using VB.NET - Hug 14-Feb-08
                        Re: Set Cell format using VB.NET - David Biddulph 14-Feb-08
                                Re: Set Cell format using VB.NET - Hug 14-Feb-08
                                        How about adding spaces as filler to make fields even length - Mehdi Anis 01-Oct-08
                                Re: Set Cell format using VB.NET - Harlan Grove 15-Feb-08
        format excel worksheet in vb.net - bolton ss 09-Oct-08

Nesting countif functions
  

Search

search




Purchase