looking for example to create an excel file .xls from vb program
Posted on 2006-12-01
I can write a vb program to create a comma delimited output file. say 10 column, selected by either
comma delimited or tab delimited output file .txt
But instead for my user get confused with few steps to load comma or tab delimited txt file, then save as
xls file. I am looking for a way to 'direct' output my file into xls worksheet.
Someone told me I can write a template spreadsheet with a maccro to import the comma/tabl delimted
data. No formula in my output. I am looking for someone to give me some example , or even suggest
a better way to do this.
I certainly can make the convert comma delimeers txt file to import to xsl in a batch file, and my VB program can 'spawn' a processor to execute.