<div>
Thank you so much Wayne.<br />
For an update I did not have the interop references on a clean install and had to download them from -<br />
<a href="http://download.microsoft.com/download/c/4/8/c4813cc0-a4d4-4bb4-b486-9cbd56f38235/oxppia.exe" rel="ugc nofollow">http://download.microsoft.com/download/c/4/8/c4813cc0-a4d4-4bb4-b486-9cbd56f38235/oxppia.exe</a><br />
and browse to them from the project<br />
<br />
Thanks again :-)<br />
Pavlo
</div>


Thank you so much Wayne.
For an update I did not have the interop references on a clean install and had to download them from -
http://download.microsoft.com/download/c/4/8/c4813cc0-a4d4-4bb4-b486-9cbd56f38235/oxppia.exe [http://download.microsoft.com/download/c/4/8/c4813cc0-a4d4-4bb4-b486-9cbd56f38235/oxppia.exe]
and browse to them from the project

Thanks again :-)
Pavlo

<div>
What Imports did you use for this?<br />
<br />
I'm trying to do this in a SSIS Script Task, which allows you to write VB.NET to achieve certain things.<br />
<br />
Is it possible to do this on a server that does not have Excel installed?<br />
<br />
Thanks,<br />
<br />
Pete
</div>


What Imports did you use for this?

I'm trying to do this in a SSIS Script Task, which allows you to write VB.NET to achieve certain things.

Is it possible to do this on a server that does not have Excel installed?

Thanks,

Pete

<div>
<div class="content wysiwyg-content">
Trying to use VB.NET to convert excel files to csv.<br />
<br />
Code below - <br />
Dim xlBook As Excel.Workbook<br />
xlBook = GetObject(&quot;C:\excelstore\b<wbr />ook1.xls&quot;)<wbr /><br />
&nbsp;xlBook.SaveAs(Filename:=&quot;c<wbr />:\TEST.csv<wbr />&quot;, FileFormat:=&quot;CSV&quot;)<br />
<br />
When I run this I get a Com Exception error<br />
<br />
Using VS 2005 and Excel 2003
</div>
</div>


Trying to use VB.NET to convert excel files to csv.

Code below - 
Dim xlBook As Excel.Workbook
xlBook = GetObject("C:\excelstore\book1.xls")
 xlBook.SaveAs(Filename:="c:\TEST.csv", FileFormat:="CSV")

When I run this I get a Com Exception error

Using VS 2005 and Excel 2003

VB.NET - Convert xls to csv

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.