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.