Personal.xlsb visible but not opening.

[tonybr]

Hi all. I hope you can help me as I am having a bad, bad day


I was editing a long macro earlier in VB editor and when I returned to it, my macros have all disappeared.


The PERSONAL.XLSB file is still visible in C:\Users\tt*******\AppData\Roaming\Microsoft\Excel\XLSTART which I hope is a positive.


If I try and open this file from the location above (instead of in Excel), it opens and if I click on VBA editor, I can see the modules (over 200 of them). I am unable to click on any of the modules to see their contents though.


I'm unsure why the filename at the top is PERSONAL.XLSB -[RibbonX (Code)].


I've checked that PERSONAL.XLSB isn't disabled in add-ins and it is not.


Can anyone save my job please?!



Thanks

 

[ZVI]

Hi,
File can be corrupted.
Not sure if it's possible to fix it but I can try if you upload personal.xlsb and provide the link to it

 

[tonybr]

Hi,
File can be corrupted.
Not sure if it's possible to fix it but I can try if you upload personal.xlsb and provide the link to it

A bit more info. I emailed the file home an I can open I there which is a great relief as at least can now copy the code.

So it appears that it is Excel itself that has corrupted. On my work laptop, I cannot create a macro at all without the message 'the syntax of this name isn't correct'. It doesn't matter what I call the macro, nothing works.

 

[tonybr]

Also, when I opened the file at home, the module I was working on previously said something like 'unable to compile code as too long' so I guess this is what caused the problem.

 

[ZVI]

Glad you have sorted it out!
200 code modules looks huge. It's known that each VBA module has 64K limit, but not sure about total code size limit.
Instead of putting code into the personal.xlsb only, you may also put it into AddIns to split code if its total size is an issue.
Cheers!