<div>
Other possible way is check if file already exist, delete it and saveas normally.<br />

</div>


Other possible way is check if file already exist, delete it and saveas normally.


<div>
Thanks for &quot;A&quot; grade.
</div>


<div>
<div class="content wysiwyg-content">
Hi How do I use VB to change Excel format from CSV to Excel Workbook with same filename?<br />
<br />
I open it using Excel.Application<br />
One way that work is that using SaveAs , and set file format to xlExcel9795, but the problem is that it will prompt a dialog &quot;Do you want to overwrite it? Y/N/C&quot;. &nbsp;I want it to automatic saved without display dialog, if file exist, just overwrite.<br />
<br />
Or is there anyway to just change the fileformat of Excel CSV to Excel Workbook and saved.<br />

</div>
</div>


Hi How do I use VB to change Excel format from CSV to Excel Workbook with same filename?

I open it using Excel.Application
One way that work is that using SaveAs , and set file format to xlExcel9795, but the problem is that it will prompt a dialog "Do you want to overwrite it? Y/N/C".  I want it to automatic saved without display dialog, if file exist, just overwrite.

Or is there anyway to just change the fileformat of Excel CSV to Excel Workbook and saved.


how to change Change Excel Format?

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.