 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / August 2007Crash on running macro
Hi. I'm using Excel 2004 on a iMac G5 with the latest OS and updates etc etc. My Microsoft preferences have been trashed and I've repaired permissions. I rarely use Excel and only in the most basic way. But today I'm creating some charts and cleaning up some data and it occured to me that a macro would speed things up. So I created a very simple macro to remove the character "m" from some numbers. Excel consistently gets the spinning beach ball after running the macro. I tried creating another simple macro--just as an experiment--in another workbook and it, too, instantly freezes up Excel. So I'm thinking that perhaps something about running macros in itself is causing a problem, and not anything with any particular macro. Any ideas? > So I'm thinking that perhaps something about running macros in itself > is causing a problem, and not anything with any particular macro. Any > ideas? It's hard to tell without seeing your macros. XL is not inherently prone to crashing while running macros, though there are certainly some instability issues for certain methods. Do you have any add-ins loaded? Did you trash your preferences with all Office applications closed? What OS and XL versions are you using? > It's hard to tell without seeing your macros. XL is not inherently prone > to crashing while running macros, though there are certainly some [quoted text clipped - 4 lines] > > What OS and XL versions are you using? Thanks for the reply. Don't have any Excel-related add-ins loaded. Yes, preferences were trashed with no MS apps running. Excel 11.3.6 Mac OS X 10.4.10 Here is the macro--it's so simple that I can't believe it's the problem: Sub remove_extra() ' ' remove_extra Macro ' Macro recorded 8/22/2007 by George Krompacky ' ' Keyboard Shortcut: Option+Cmd+k ' Selection.Replace What:="M", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False Selection.Replace What:="$", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False End Sub > Excel 11.3.6 > Mac OS X 10.4.10 > > Here is the macro--it's so simple that I can't believe it's the > problem: I agree. It works fine for me. FWIW, XL's latest version is 10.3.7, but I also don't think that's the problem. Does the crash happen with a fresh workbook? What do you have selected when you try to run the macros? > In article <1187813581.966116.19...@q3g2000prf.googlegroups.com>, > [quoted text clipped - 4 lines] > > What do you have selected when you try to run the macros? That's odd, selecting "About Excel" or examining in the Finder both show 11.3.6 for me LOL. I'm starting to think that this problem is tied into overall weird Excel behavior re: saving a newish document. I can't pin down the actual behavior, but often when I start an Excel document, I'll type in a couple of cells and then think I'd better do a save. It's at that point that Excel crashes. Like I said, I don't need to use XL that much, and I've gotten to the point where I sort of trick it into starting a new document without crashing, by saving first, or saving after one or two keystrokes only. I find if I can just get the document saved, and then it crashes, I can delete preferences, open the saved document and then not have any problem. It's just starting a new document that is plagued with crashes. So, perhaps a reinstall of Office is in order. I'm on top of all the usual OS X maintainance fixes--fonts are okay etc--and no other application is misbehaving but XL. > So, perhaps a reinstall of Office is in order. I'm on top of all the > usual OS X maintainance fixes--fonts are okay etc--and no other > application is misbehaving but XL. Probably worth a shot, but I'd guess that by itself it will have zero effect, simply because applications almost never corrupt, while preferences often do. If you do reinstall, make sure you run the Remove Office application to uninstall, rather than simply trashing the application folder. If you have a Personal Macro Workbook, or any other file in your startup folder (by default it's HD:Applications:Microsoft Office 2004:Office:Startup:Excel though you can set an alternate in Preferences/General), I'd try trashing/moving that file first. > Probably worth a shot, but I'd guess that by itself it will have zero > effect, simply because applications almost never corrupt, while [quoted text clipped - 9 lines] > though you can set an alternate in Preferences/General), I'd try > trashing/moving that file first. Yes, in all honesty I don't think it will do anything either LOL. I don't have any start-up Office items. However, while browsing those folders I realize that there are some add-ins. This is my office computer and I'm assuming these are all add-ins from the default Office installation but I suppose i could be wrong. Please let me know if anything here is should be trashed... In /Applications/Microsoft Office 2004/Office there is ExcelPrintPDE.plugin In /Applications/Microsoft Office 2004/Office/Add-Ins there are Conditional Sum Wizard Eurotool.xla HTML.XLA Lookup Wizard Report Manager Set Language Solver.xla and in /Applications/Microsoft Office 2004/Office/Add-Ins/Analysis Tools there is Analysis ToolPak Analysis Toolpak - VBA FuncRes ProcDBRes > This is my office computer and I'm assuming these are all add-ins > from the default Office installation They are. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.