Insert new worksheet into exsisting excel workbook

Topics: Developer Forum, User Forum
Apr 1, 2009 at 1:27 PM
I am trying to read an excel workbook of 20 worksheets with complex formula and it is taking around 7-10 minutes for the whole process, it take 5 minutes to read the content then another 2-5 minutes to write content into a new file. I have disabled pre-formula calculation it reduced it by 3 minutes which is not enouhg.
I have found away to load just the worksheet that I want to modify, but I couldnt find away to create a worksheet and apend it into existing excel workbook w/o reading the whole content of the workbook.
Apr 2, 2009 at 5:58 AM