Return-Path: Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 4533 invoked by uid 98); 13 Dec 2002 00:20:27 -0000 X-Antivirus: nagoya (v4218 created Aug 14 2002) Received: (qmail 4510 invoked from network); 13 Dec 2002 00:20:25 -0000 Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142) by nagoya.betaversion.org with SMTP; 13 Dec 2002 00:20:25 -0000 Received: (qmail 11696 invoked by uid 500); 13 Dec 2002 00:19:09 -0000 Received: (qmail 11686 invoked from network); 13 Dec 2002 00:19:08 -0000 Received: from windscape.com (HELO snowball) (64.35.57.100) by daedalus.apache.org with SMTP; 13 Dec 2002 00:19:08 -0000 Received: from [65.188.233.21] by snowball with SmartMax MailMax for poi-user@jakarta.apache.org at Thu, 12 Dec 2002 19:28:39 -0500 Message-ID: <1039739319.26199@snowball> From: "Dale Bronk" To: "POI Users List" Subject: RE: Excel not calculating Date: Thu, 12 Dec 2002 19:14:48 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 In-Reply-To: <1039708640.19945@snowball> Importance: Normal X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Ok... I found where/how to enter this as a macro. Problem is it really doesn't help and causes the output from POI HSSF to not be able to be opened. I added the macro in my POI saved excel workbook and it worked great. I then added the macro into my base excel workbook. Ran my program that reads my base workbook, enters data into a couple entry cells, and then saves it out to a new excel file. When trying to open the new file I get a File Not Found error. Looks like POI does not handle macros and the users are going to be loading data into these sheets a ton so I can't have them manually enter the macro each time. Any other solutions? This is a huge show stopper for me. Any one know why Excel does not recalc even when I click F9-recalc? My entire design is based on this working so I am beginning to panic a bit as the alternative is really ugly. Thanks, Dale -----Original Message----- From: Dennis Doubleday [mailto:dennis@righthandmanager.com] Sent: Thursday, December 12, 2002 10:35 AM To: 'POI Users List' Subject: RE: Excel not calculating I have the following in my templates: Private Sub Workbook_Open() Application.ScreenUpdating = False 'Make the entire workbook recalculate. Can be 'done with Application.CalculateFull in Excel2000 'but this is back-compatible to Excel97. SendKeys "%^{F9}", True End Sub Seems to work. -- To unsubscribe, e-mail: For additional commands, e-mail: