How to set Cell Format using VB.NET

H

Hugh

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()
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Cell format using VB.NET 14
How to use/create code in MS Word to calculate age? 0
Trouble exporting ado rs to Excel 3
VBA - exporting serial letters to single documents 0
Which code lines attached, keep me in current instance of Excel? 0
Word macro that can call cells out of Excel for a find and replace 0
Using excel solver in VB.NET 7
How to reference a file in a different instance of Excel? 4

Top