For some reason unknown to me (VBA newbie) a macro that I have been using for a couple years now returns a "Code Execution has been interrupted" error. when I debug it it stops at the 'Set Lworkbook=Activeworkbook' code line.
I'm using Excel and Outlook 2013 versions
Please Login or Register to view this content.
It works fine for me in Excel 2013.
Is it possible your workbook is protected?
Last edited by mikeTRON; 05-05-2016 at 12:41 PM.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
That's odd. Yes my workbook is protected but it breaks before even getting to that point.
I even created a new excel file and the macro still fails at the same point.Please Login or Register to view this content.
Yeah I copied and pasted your exact code into a new workbook and it worked flawlessly.
Activeworkbook is somewhat ambiguous though, as I wouldn't recommend using it. I would suggest trying to explicitly defining LWORKBOOK instead and see if that helps.
Well apparently it is something specific to my excel only. I just tried it from a co-worker's pc and it worked fine. Any ideas what in excel settings may be causing it. I don't recall making any changes to settings
Anytime I have issues like this I juts wash my laptop in the dishwasher and let IT figure it out. :D
Seriously, I have NO idea why your's would bomb and your coworker's wouldn't. Maybe check and see if you have any windows updates. Then you can also try seeing if you have any ADD-INs installed that your coworker doesn't.
The problem I would have with specifying the workbook name is that it changes with every use based on the network folder it is saved in.
I have my excel configured exactly the same as the other pc I tested it on and no luck. Looks like a reinstall of excel may be in order
Sorry for the obvious question... but you have rebooted since you had the issue?
You can specify the workbook in other ways that just name or ActiveWorkbook... for example "ThisWorkbook" would be the one containing the code, which is still more explicit than activeworkbook.
ie:
I know that particular application does nothing for this case... just realized it is your new workbook...Please Login or Register to view this content.
Last edited by Arkadi; 05-05-2016 at 03:22 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
With MS not sure anything is obvious but yes I have restarted since this problem started. I just uninstalled and reinstalled excel and the issue now moves past that point and breaks at. If i try to continue It will actually complete as expected so maybe I'm getting closer.Please Login or Register to view this content.
It doesn't help that since I'm pretty new to this I don't fully understand what each line actually means
I went ahead and made your recommended change as well.
Wanted to update the thread that this issue has been resolved. In addition to the issues above I started receiving the error "VBA Objet Error-Class not registered.Looking for object with CLSID:{AC9F2F90-E877-11CE-9F68-00AA00574A4F}"
After trying every solution found online, most of which applied to previous versions of excel anyways, I was forced to completely uninstall MS office suite, clean the registry of any remnants and reinstall office. So far none of the issues have returned.
Thanks for all the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks