<div>
I did find that just a few minutes ago but thanks. <br />
<br />
You get the points man!<br />
<br />

</div>


I did find that just a few minutes ago but thanks.

You get the points man!



<div>
<div class="content wysiwyg-content">
Need to be able to save an Excel file to CSV in a client side VBScript in an ASP.NET 2.0 app.<br />
<br />
This following code works fine until the SaveAs. &nbsp;Excel.XlFileFormat.xlCSVWi<wbr />ndows seems to be undefined.<br />
<br />
Set appExcel = createobject(&quot;Excel.Applic<wbr />ation&quot;) <br />
Set myworkbook = appExcel.workbooks.open(fi<wbr />leName) <br />
Set allwShts = myworkbook.Worksheets<br />
...do some work...<br />
fileNameCSV = left(fileName, len(fileName)-3) &amp;&nbsp;&quot;.csv&quot;<br />
myworkbook.SaveAs fileNameCSV, &nbsp;Excel.XlFileFormat.xlCSVWi<wbr />ndows<br />
<br />
Here's another guy with the same problem...<br />
<a href="http://www.thescripts.com/forum/thread223814.html" rel="ugc">http://www.thescripts.com/forum/thread223814.html</a><br />
<br />
There are only two pages returned from Google when searching &quot;Excel.XlFileFormat.xlCSVW<wbr />indows&quot;<br />
<br />
Can I hard code a value for the call to SaveAs?<br />
<br />
<br />

</div>
</div>


Need to be able to save an Excel file to CSV in a client side VBScript in an ASP.NET 2.0 app.

This following code works fine until the SaveAs.  Excel.XlFileFormat.xlCSVWindows seems to be undefined.

Set appExcel = createobject("Excel.Application") 
Set myworkbook = appExcel.workbooks.open(fileName) 
Set allwShts = myworkbook.Worksheets
...do some work...
fileNameCSV = left(fileName, len(fileName)-3) & ".csv"
myworkbook.SaveAs fileNameCSV,  Excel.XlFileFormat.xlCSVWindows

Here's another guy with the same problem...
http://www.thescripts.com/forum/thread223814.html

There are only two pages returned from Google when searching "Excel.XlFileFormat.xlCSVWindows"

Can I hard code a value for the call to SaveAs?




Save an Excel file to CSV in a client side VBScript in an ASP.NET 2.0 app.

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.

.NET Programming

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications