hello,
well i need a code in vb6.0 that could directly save my csv file to xlsfile
well i need a code in vb6.0 that could directly save my csv file to xlsfile
-
-
Hi, i dont know if there's an easy way, but you can open the cvs in an excel application and then save itOriginally posted by NEHU
it should be something like
[CODE=vb]dim obj1 as object
set obj1=createobje ct("excel.appli cation")
obj1.workbooks. open ("C:\myfile.csv ")
obj1.workbooks( 1).saveas ("c:\myfile.xls ")[/CODE]
HTH
Comment