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.