Extra Sheets In Excel VBA - Corrupt Workbook Help
ฝัง
- เผยแพร่เมื่อ 4 ต.ค. 2024
- 📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...
Hi Dan.. great tip! I have not run into the corruption you demonstrated, but nice to know the solution if I do. So basically.. Export all your modules and user forms and save any event procedure code at the worksheet or workbook level, then save the workbook to .xlsx, then close/open and Import your Modules and User Forms back in and copy and paste your event procedures back to the workbook and worksheets and then save as .xlsm. I hope I never need to do this.. but thanks for the guidance if I do. Thumbs up!!
Hi Wayne,
Yes - it sucks, but you've got it exactly correct in your description. Thanks for the comments!!
Hello my friend. Great video. Corrupt files are a pain, but I agree with your explanation and fix. Not much else you can do.
Thats really benefit tip, Thanks.
good evening i have a problem with a vba because im trying to do for loop and the steps that they give me i dont understand them quite a bit i want to know if you can help do it
The best method is just to make a backup of each saved workbook everyday in a different folder.
there is no easy button?
For you - I'll make one, "Galvin"! 😀😀
In VBA project window, microsoft exel object and sheet name is not visible. Any solutions
Hi Kalai,
Sure, you may need to get your Project Explorer back up using Ctrl+R or go to View->Project Explorer. Then it will come back.
Hope that helps.
Thanks
Dan
@@ExcelVbaIsFun in project explorer window, expand option is not available.
@@kalaianbu4881 Hmmm. Can you share a screenshot using a file sharing or screen share URL? What do you see? Is it a password protected project that won't open without a pw? Is there only 1 sheet or only one module?
Thanks
Dan
@@ExcelVbaIsFun i dont know how to share screenshot in you tube. In my excel i have more no of sheets . i want to consolidate into one sheet. if i open vba editior, in window explorer it is showing only file name. if we click the file name all sheet name should be visible right. but i can't able to click or expand the file. if you give your mail id i will share as image
@@kalaianbu4881 You should be able to paste screenshots in our Excel Ninjas group here excelvbaisfun.com/ninja
Thanks
Dan