top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+6 votes
253 views

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.

posted Nov 11, 2013 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+3 votes
 
Best answer

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
answer Dec 3, 2013 by Prachi Agarwal
Similar Questions
+1 vote

I am searching for a offline tool to check cross browser compatibility, Is there any?

+1 vote

Hi All,

I am facing X2 setup failures in some sites. What will be possible reasons apart from transport issues. Can we optimize the issue from RF perspective? Kindly help me in this

+1 vote

Does anybody know if there's anyway to upload a .xlsx file and then convert it to .xls file for later processing?

I'd like to use spreadsheet to write a new xls file but it doesn't support xlsx and the file is only importable with that format sadly. I saw roo but I don't know if there's a direct way to do it.

...