Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Viveka Fischer   on Sep 06 In MS Office Category.

  
Question Answered By: Bes Massri   on Sep 06

Well, first off, I'm wondering if you have cleaned your
code . . . and I am saying that because I had a similar problem
(when I was trying to make a macro  pretty much bombproof) which made
me work hard to figure out why a subroutine crashed when I had been
stepping thru it line by line and it crashed at a point where there
was no code showing in the VBA editor. I've become a bit obsessive
about backing up and cleaning the code I write since then, but
perhaps that's not simply a mental disorder (heheh, I hope). I
have used the freeware code cleaner found at:
http://www.appspro.com/Utilities/CodeCleaner.htm
and I have also just copied the text version of the code out to a
textfile and back . . . both seemed to be the same so I have
continued to use the AppsPro code cleaner successfully.

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Can't open excel file after editing macro Or get search suggestion and latest updates.


Tagged: