| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007
Thanks for your thoughts Simon.
"Simon Lloyd" wrote: One other thing of note is, i believe, that Excel 2003 can only ever consume a maximum of 1Gb of memory, where Excel 2007 can be as voracious as the system allows. Maybe you have too many processes going on, is it a single core processor?, perhaps you should hit Ctrl+Shift+Del and look at the processes running and how much CPU resources are being taken by the particular processes, and, if possible, turn them off. Bob Phillips;209198 Wrote: Quite honestly mate, that sounds like a system problem, I don't suffer such problems. Responded on the other thread too! -- __________________________________ HTH Bob "Brettjg" wrote in message ... Hi Bob, thanks for your thoughts. Here's a typical example of the rubbish I have to put up with in Excel 2003. While a macro was running just now, you sent me your response, so I clicked on "Read the response" in Outlook, and Excel crashed. I would have thought that you should be able to use a modern computer with more than one window while a macro is running. BTW, I posted a further question to your about the bold font thing. The Textframe doesn't work with a shape array apparently. Thanks, Brett "Bob Phillips" wrote: I run Excel 2003 extensively, for some intricate applications, and I just do not get the regular crashing of Excel that you describe. In fact 2003 is by far the most stable, the best Excel that I have ever used. Excel 2007 has had a fair amount of work to make it more efficient, and more secure, but not stable AFAIK. The VBA is not very different and so should not present too many compatibility issues (biggest change is probably that FileSearch is gone), but the object model is very different and may require coding changes. There is no simple answer I am afraid, it is a case of migrating and testing it. I have many apps that have migrated with no changes, many that have needed changes, but in most cases where the change has been larger has been because I decided to do different thins in the 2007 version. The other thing to note is that 2007 is very different in terms of the user experience than 2003. Some love it, some don't - it is the marmite of spreadsheets. -- __________________________________ HTH Bob "Brettjg" wrote in message ... Hello out there. I'm currently using XP 2003 with Excel 2003 and I've got a particular suite of pretty intricate spreadsheets that use about 1mb of VB code. I've heard that upgrading to Excel 2007/Vista is not so easy to do because of incompatibility, and I don't want the grief of a complete rewrite/modification. On the other hand I'm sick to bloody death of Excel 2003 crashing because it feels like it. What are your thoughts please? I'm happy to hear many views on this. Regards, Brett. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57386 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 files not showing on screen when opened in Excel 2007 | Setting up and Configuration of Excel | |||
| Conflict in excel 2007 with Outlook 2007 attachment excel | Excel Discussion (Misc queries) | |||
| Labels: Unable to import all records Excel 2007 to Word 2007 Mailm | Excel Discussion (Misc queries) | |||
| Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please | Excel Programming | |||
| Excel 2007 Macro Help (Excel 2003 not working in 2007) | Excel Discussion (Misc queries) | |||
Linear Mode
