<div>
What will the user run, once they receive the .csv file? Default would be Excel, is that your preferred solution?
</div>


What will the user run, once they receive the .csv file? Default would be Excel, is that your preferred solution?

<div>
Hi Borki, Ideally they need to use Excell (to do stock calculations etc.)
</div>


Hi Borki, Ideally they need to use Excell (to do stock calculations etc.)

<div>
Hi Capricorn1, that's great, works perfect. Thanks!<br />
<br />
I used &nbsp;-4143 and also:<br />
<br />
if xlfile&gt;&quot;&quot; then kill xlfile<br />
<br />
Thanks again.
</div>


Hi Capricorn1, that's great, works perfect. Thanks!

I used  -4143 and also:

if xlfile>"" then kill xlfile

Thanks again.

<div>
<div class="content wysiwyg-content">
I have an access app that outputs all the rows of a database table. I had to output to csv as excel has a row limitation. The app then sends the file as an email to various people, they then have to save as XL to add formatting etc.<br />
Does anyone know how to convert the csv into xls/xlsx using VBA?
</div>
</div>


I have an access app that outputs all the rows of a database table. I had to output to csv as excel has a row limitation. The app then sends the file as an email to various people, they then have to save as XL to add formatting etc.
Does anyone know how to convert the csv into xls/xlsx using VBA?

Access 2007 csv to Excel

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

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.