Excel vba - file not found

Question

Hi All,

A few days I was working on an Excel vba add-in and don't know what went wrong - I tried to remove a module - but I see it is still there and I cannot open it anymore. And having the error "file not found".

Is there anyway to recover from this? TIA.

Answer 1

Hi All,

After tenths of trials and days of retrial, I managed to fix it. By reversing the changes I would apply it was pinpointing more and more to the last step, removing the module. Starting by copying the constants and removing the module, save it; close and restart Excel, I could implement all other changes without problem.

Don't ask me why this worked. Maybe one of you knows.

Answer 2

Hi All,

Further trying to recover and find an answer.

I have to normal modules that I want to merge to 1 because one of them contains only some public constants. So, I copy these to the other and removed the 2nd module.

When I reopen the file, the 2nd module is there again but I cannot "open" it anymore and get the "file not found" message.

I searched the project if I used something as modX. but nothing.