11-14-2010 08:23 PM - edited 11-14-2010 08:29 PM
11-14-2010 08:39 PM
No.
Write to Spreadsheet file has nothing to do with Excel. It creates a text file in a tabulated format that Excel is capable of reading by way of its import functions. There is no concept of sheets in a text file.
If you want to work with Excel and multiple sheets, you can't use the Write to Spreadsheet File function. You will have to use ActiveX commands. Search this message thread for links to other messages that discuss programming Excel with ActiveX. Excel Board