Page 1 of 1

Convert CSV to XLS

Posted: Fri Aug 29, 2008 10:23 am
by verona
Hi,I would like to combine two CSV files into worksheets in a single XLS file, and I suspect that this can be done through Basic scripting, but I'm not sure how to get started on this. (I have programming background in Java & C++ but very little in Basic/VB)Can someone point me in the right direction to get started on this?Thanks!Another question: I know I can run a task from a Basic script, but there doesn't seem to be any way to wait for it. Am I missing something?

Convert CSV to XLS

Posted: Wed Sep 03, 2008 2:39 pm
by verona
To put the question another way... is there a way to "plug into" the Microsoft OLE and/or Visual Basic for Applications from Sax Basic? Perhaps an easy way to run a saved Excel macro without opening up Excel itself? Or an easy way to run the saved macro from within Excel? (I'm using Excel 2007.)I'm certainly open to suggestions of other ways to automate the CSV to Excel conversion.