troubleshooting Question

Repair corrupted files and Clean, Trim, Loop through Folder

Avatar of Arvind Kumar
Arvind Kumar asked on
VBA
13 Comments1 Solution66 ViewsLast Modified:
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ÆìsŽ(©fàÂŒ9òBËÙ•!‹ØJˆ to be removed. Is it possible to have a VBA for these three, the loop through each file in folder until all done?

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.
Join the Community
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.

-Mike Kapnisakis, Warner Bros