Open > Click Ok on Error > Save as .xlsm

All,

I have about 51k .xls files that I converted from HTML. When I open one, I get the following error: File Error: data may have been lost

I need a macro that will open all the .xls books in C:/BoxScoreTest, bypass that error, and save as .xlsm. Is that possible?

Thanks in advance

Hey all, I got it. Thanks!

Hey all, I was wrong. The macro was working on some files but not others.

This is my macro I'm running to open the xls, make some modifications, close and save the xls. However, I'm getting a failure and the macro won't run on 99% of the xls sheets. I think its because they were converted from HTML into xls. Is there a way to tell my code when trying to open a sheet, if you get an error click ok, and then execute macro?

Please Login or Register  to view this content.

No responses here. had to buy a converter.