File with many bugs (corrupted) - need to re-do it. Tips?

[stefsj]

Hi,

I have been working on a file that has many little bugs and I reached a point where I simply want to re-do this file in order for it to work properly and not to give me various of random errors at times.

I am packing up on donuts and coffee and will have a long night in front of me but have couple of questions for anyone that has done such a process before.

First is - what can I bring over from the old file - can I at least paste as values some cells that are text only? Can I copy directly the password and paste in the cells? I don't want to bring any sort of bugs and will re-do as much as I have to.
Second - about the macro code - I will recreate the forms, but is it safe to copy and paste the code from the old file?

Thanks in advance!

 

[shg]

Before you do all that, you might want to run CodeCleaner

 

[stefsj]

Before you do all that, you might want to run CodeCleaner

Interesting, have you tried this before? I am not expecting miracles but will try.

 

[shg]

I use it regularly when making and testing mods to large VBA projects. And before that, I used to do manually what it does automatically.

 

[stefsj]

So how does it work exactly? I installed it. Should I run the code in the excel file ones my bugged file is open?

Edit: I ran it with the file open and it took a while (5-6 seconds) but after that I didn't see any change. The same bugs as I see before.
Thanks though!