AnsweredAssumed Answered

New Sheet in an Excel file

Question asked by josape1 on Jun 15, 2007
Hi

I'm using VEE 6.something. I get some data from an analyzer and then try to create an Excel file. I only found this way to create the Excel file:

Set ExcelWkbk=createObject("Excel.Sheet");
Set ExcelApp=ExcelWkbk.Application;
Set Wks1 = ExcelWkbk.WorkSheets(1);

And then I write in the first worksheet. The thing is that I've tried to write in a second one, but there's this big problem... there is no second worksheet.

So, could anyone tell me how do I create a 2 worksheets Excel file? Or.. can I add a second worksheet once I've created the file?

Thanks in advance!  

Outcomes