Hi,
Could someone be able to tell me how I open an excel file and save it as a text file.
I need to format it as a text file
tks
Printable View
Hi,
Could someone be able to tell me how I open an excel file and save it as a text file.
I need to format it as a text file
tks
In Excel choose file -> Save As
The just choose the tabbed (*.txt) or the CSV format. Both are ASCII exports. The same functionality can be controlled from VB. In VB you'll have to set a reference to the Excel object library and make an Excel.Applicatio object. Just record a macro in Excel and look at the code for the export.
hope this helps,
Rick