Access VBA code in corrupted workbook

[DEksel]

Incidentally, I've saved my Excel .XLSM Workbook with 2 macros with the absolutely same name. Forgot to rename the macro copy. Now, I can't open that workbook. Simple, no way! Is any way for this problem to be solved? Maybe to export codes to bases or text from another book? I am really, really(!!!) desperate. Need to save many hours of repeated works.

Thanks in advance.

 

[DEksel]

Actually, it wasn't macro (as Sub ... End Sub) but Function. I am using them instead of macros. But this can't be the issue probably...

 

[Fluff]

As the project isn't protected, you should be able to get in & change the name of the function, if you can't it sounds as the the workbook may have become corrupted.
Try following the steps shown here https://support.office.com/en-gb/ar...workbook-153a45f4-6cab-44b1-93ca-801ddcd4ea53

 

[DEksel]

I already did. Nothing works for that book. I have no access to VBA project. Sure I can rename if I see it. The only moment which is incredible is that guys from the next site https://www.coolutils.com/online/XLSM-to-XLSX online converted it to XLSX perfect in few seconds. They should use Python or PHP or ASP... Now I have all tables, data etc. No VBA! I wrote to them too (online form). Maybe they will answer.

 

[Fluff]

That site just converts files & by converting an xlsm file to an xlsx file, you will automatically lose all macros.

 

[DEksel]

I know but they had to open the file first! They could I can't! Some of procedure works forever (mouse busy) and then error. Simple rename xlsm to xlsx does not work. Maybe they can extract VBA from opened file... some coolutils or similar... Some guy wrote the code ExportVisualBasicCode which works perfect. But WB must be opened / active. It can't work with closed WB. Thank you for your time... if no solution till tomorrow, I will start to write all of that again... I can post full code here but don't know how about the credits...

For Each VBComponent In ActiveWorkbook.VBProject.VBComponents

 

[DEksel]

I know. But they could open my WB, me not.

 

[sandy666]

maybe share your file here

 

[DEksel]

Workbooks can't be attached in this forum. I've sent to you link on that file (7ZIP archive.)

 

[DEksel]

Do you have any macros that run automatically when the workbook opens?

In ThisWorkbook all procedures are commented (I have source file). But I have some cell(s) with onChange events in 2 worksheets. Maybe they calls some action, vba checking out it's quality, finding double procedure and reject to open?

 

[sandy666]

try this deksel.zip