Convert workbooks in a folder from xls to xlsx

[carlito2002wgn]

Hi,

Can someone help with some code that goes through a folder of workbooks that are saved as xls files, and convert them to xlsx files?

Thank you!

[jolivanes]

Have a peak here.
https://www.rondebruin.nl/win/s5/win001.htm

[FDibbins]

There is no "code" to change the file types, you need top open each file, and Save As for the other file format (the code in the link above does that for you)

[carlito2002wgn]

Thank you, Jolivanes. I'm such a newb that I can't even make the code in the link you provided work for me. Ultimately, I don't even need to convert the file format. It would be nice, but not necessary.

I have some code that loops through several workbooks in a folder, performs some actions, and then closes the workbooks. When the code closes the workbooks, I get the following message:

Excel-Compatibility-Checker-Dialog.png

Is there a way that I can suppress this message message from popping up for every file? If that is possible, then I really don't need to convert the files to the later file format.

Edit: I think I found what I was looking for:

ActiveWorkbook.CheckCompatibility = False
ActiveWorkbook.CheckCompatibility = True

[jolivanes]

You could try

Please Login or Register  to view this content.

If you want to convert, this might be a solution for you.
http://www.eileenslounge.com/viewtopic.php?f=27&t=27341