This Question is Answered
anon
What Is The VB.Net Code For Converting .CSV Files Into Excel Files?
asked 2 years ago
try this:
======
Sub ConvertFile()
Dim xlobj As Excel.Application
Set xlobj = CreateObject("Excel.Application")
xlobj.Workbooks.Open "\\Dwdf051\mw\Info_Exchange\BM.cvs"
' xlobj.Visible = True
' Save to "My Documents"
Call xlobj.ActiveWorkbook.SaveAs("myFileName", xlWorkbookNormal)
End Sub
answered 2 years ago
Ask questions on any topic, get great answers from real people for FREE. Blurtit has hundreds of thousand of members so your sure to get the answer your looking for.