Can anybody help me in providing script which converts .xlsx to xls

Question

I want to convert office 2007 file to 2003 format, it will be great, if somebody have done something similar to this in visual basic.

Answer 1

You can use below for loop to process through each file present in Ofolder

For Each File In oFolder.Files

   Set wb = xlApp.Workbooks.Open(File)
   wb.SaveAs Replace(wb.FullName, "xlsx", "xls"),
   wb.Close False
   Next