VBA (Visual Basal for Applications) macros accredit you to extend Microsoft Excel features. Using macros, you can automate the formatting, charting and additional often-performed tasks. You can aswell use them to affectation custom forms and collaborate with additional applications. But at times, you beam that your Excel spreadsheet is base and you can`t accessible the file. One of the accessible causes could be macro corruption. In such situations, you charge to restore data from your contempo data backup. However, if data advancement is unavailable, not abreast or damaged, Excel accretion accoutrement can be acclimated to adjustment and restore the absent data.
Consider a applied scenario, you accessible an Excel book that contains VBA macros and attenuate the macros. Afterwards this, you adapt the VBA cipher and save it. Next time, if you accessible the book with macros enabled, the book fails to open. Alternatively, if you try to accessible the aforementioned XLS book with macros disabled, the appliance hangs and you can`t admission your file.
The Excel book is besmirched or damaged. If you create some changes in the VBA cipher while you accept disabled the macros, they get corrupt. If you reopen the spreadsheet and accredit the macros, they do not run appropriately and base the file.
To boldness the aloft issue, you charge to chase these methods:
Try aperture your damaged XLS book with `Open and Repair` feature
Save the book in HTML format. This allows your book to clarify out some information
Save the damaged book in XML spreadsheet format
If there is a blueprint that is affiliated to the damaged spreadsheet, you can use a macro to abstract data
If the problem persists, you charge to use your contempo data advancement to restore the afflicted files
Tags: charge, accessible, afterwards, excel, damaged, spreadsheet, restore
Also see ...
Article In : Computers and Technology - Data Recovery