I have a macro that is setup like this (see below). When running the macro, it causes excel 2010 to crash. I have commented each line out and it is the ActiveWorkbook.close line that is causing the problem. Currently I just have to manually close the workbook. Why would Excel 2010 not like this line of code?
Please Login or Register to view this content.
Last edited by kahss33; 11-15-2011 at 09:52 AM. Reason: add code tags
Hi, and welcome to the forum.
Is the code in that workbook? Does this fare any better:
Note: I added code tags to your post as it's your first post. Please learn to use them when posting code in future.Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
It may not have anything to do with your problem, but I kept having a workbook crash on me and I realized that I had two macros with same name.
Yes, the code is contained within the workbook.
How are you calling the code and did you try my version (if so, did it have the same issue)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks