The macro still crashes excel. I do have ad-ins, Bloomberg and FactSet are the two main ones aside from the Excel created ones like Solver and such. The macro is able to complete but just as it finishes and Bloomberg is retrieving data, it crashes. Hopefully this bit of data helps. Quit all the office applications and then drag these files and folder on the desktop “User Home folder – Library – Preferences – com.microsoft.Excel.plist” and “User Home folder – Library – Preferences – Microsoft”. 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. Crash on running macro. Posted:, 07:54 PM In article, wrote: > So I'm thinking that perhaps something about running macros in itself > is causing a problem, and not anything with any particular macro. 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? Install pydot for mac. Posted:, 08:13 PM On Aug 22, 12:54 pm, JE McGimpsey wrote: > 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? 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. Posted:, 08:51 PM On Aug 22, 1:29 pm, JE McGimpsey wrote: > In article, > > 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? My passport for mac kabel. > > 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. Posted:, 10:10 PM In article, wrote: > 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 Rufus to create usb bootable. 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. Posted:, 10:23 PM On Aug 22, 3:10 pm, JE McGimpsey wrote: > 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.
0 Comments
Leave a Reply. |