troubleshooting Question
Repair corrupted files and Clean, Trim, Loop through Folder
Arvind Kumar asked on
Hello. I am nil at VBA. Probably will never use excel again after current use,
I have 2500 Excel 2013 (XLSX) files, corrupted because recovered after HDD Volume was deleted by mistake.
Hence two questions.
1-When file opened, excel asks to repair, I click Yes, in few seconds corrected file ready to be save.Possible to have VBA to Automate the process?
2-Many files need to be trimmed for extra space, Non printing characters to be removed, and characters like ***++Ášê›‰$‰$‰$‰$å„%f/1ûmÆ
Please let me know if I needed to post both questions separately. Thank you.
I have 2500 Excel 2013 (XLSX) files, corrupted because recovered after HDD Volume was deleted by mistake.
Hence two questions.
1-When file opened, excel asks to repair, I click Yes, in few seconds corrected file ready to be save.Possible to have VBA to Automate the process?
2-Many files need to be trimmed for extra space, Non printing characters to be removed, and characters like ***++Ášê›‰$‰$‰$‰$å„%f/1ûmÆ
Please let me know if I needed to post both questions separately. Thank you.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 13 Comments.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.