TheAntiGates
07-09-2017, 07:28 AM
Mine is massive including multiple forms and modules. I suspect corruption so wish to reconstruct it (a couple of module level variables stopped responding to shift-F2, and now when I save changes in VBA Excel crashes). At least it's not a fully catastrophic corruption; everything seems to work, and vitally, I can still export VBA to text files.
One note that probably doesn't change things: I have so many macros that I've not only got multiple modules but multiple workbooks too. \XLSTART\ has a couple of friends living with personal.xls that I treat exactly the same way.
Here's my plan:
- Nothing to do outside of VBA; only empty worksheets.
- Create newest VBA exports to text files .BAS, .CLS, .FRM, and .FRX from Modules, Class Modules, Forms, ThisWorkbook, and Sheet code.
- I periodically accumulate (don't overwrite) generational copies when I modify code and forms, so I'll do text compares to see if I observe any radical/suspicious changes.
- Write down references in Project window (Control-R). I don't know how to export those.
- Visually browse tools/references and write down what was checked.
- Visually browse through every property in each Project Window object and write down anything that appears to be a "non-factory setting".
- Write down, copy/paste macro shortcut letters and descriptions by browsing through alt-F8 in Excel. (I don't know if importing the text .BAS files restores them. I do note that there are ATTRIBUTE statements in .BAS, one for the shortcut key and one for the description, which contain the shortcut letter and description.)
- Write down all VBA window customized menu items. The (insert prohibited banned words here: a$$^&*E Mo%&#@ F*%&$r) Microsoft interface designers have not yet destroyed the menu interface in the VBA window with a D.A. ribbon, so the customized accelerated shortcuts are valuable. However I don't know how to export that information (text file would be ideal).
- Write down any add-ins (actually, I've never seen one in my VBA window).
- Write down any digital signatures.
- Write down any VBA tools/options (in case I reinstall, something I'm really hesitant to do, really a last resort).
So, anything else, or other advice? I'm really hoping that I can delete personal.xls, reimport the text files, manually make the other changes written down above, and get back to exactly where I was.
One thing I will have to cross my fingers on are the .FRX graphics files for forms. I don't have the same comfort level with those as the pure text files. I'll just have to hope the saved ones will reimport unblemished.
TIA
One note that probably doesn't change things: I have so many macros that I've not only got multiple modules but multiple workbooks too. \XLSTART\ has a couple of friends living with personal.xls that I treat exactly the same way.
Here's my plan:
- Nothing to do outside of VBA; only empty worksheets.
- Create newest VBA exports to text files .BAS, .CLS, .FRM, and .FRX from Modules, Class Modules, Forms, ThisWorkbook, and Sheet code.
- I periodically accumulate (don't overwrite) generational copies when I modify code and forms, so I'll do text compares to see if I observe any radical/suspicious changes.
- Write down references in Project window (Control-R). I don't know how to export those.
- Visually browse tools/references and write down what was checked.
- Visually browse through every property in each Project Window object and write down anything that appears to be a "non-factory setting".
- Write down, copy/paste macro shortcut letters and descriptions by browsing through alt-F8 in Excel. (I don't know if importing the text .BAS files restores them. I do note that there are ATTRIBUTE statements in .BAS, one for the shortcut key and one for the description, which contain the shortcut letter and description.)
- Write down all VBA window customized menu items. The (insert prohibited banned words here: a$$^&*E Mo%&#@ F*%&$r) Microsoft interface designers have not yet destroyed the menu interface in the VBA window with a D.A. ribbon, so the customized accelerated shortcuts are valuable. However I don't know how to export that information (text file would be ideal).
- Write down any add-ins (actually, I've never seen one in my VBA window).
- Write down any digital signatures.
- Write down any VBA tools/options (in case I reinstall, something I'm really hesitant to do, really a last resort).
So, anything else, or other advice? I'm really hoping that I can delete personal.xls, reimport the text files, manually make the other changes written down above, and get back to exactly where I was.
One thing I will have to cross my fingers on are the .FRX graphics files for forms. I don't have the same comfort level with those as the pure text files. I'll just have to hope the saved ones will reimport unblemished.
TIA