I am looking for DOS .bat file/script to convert the .xls files from
v2.1 to latest .xls format.
So this .bat file/script should open .xls file(presently in 2.1v) and
save it with same name in latest .xls version available on that
machine.
Any pointers in this regard.....mail me to- kooldudeno1@gmail.com
I have written this but its is not changing the version
{
'script starts
strfolderOld = InputBox("Enter input files directory Location?")
strfolderNew = InputBox("Enter output files directory Location?")
Set fso = WScript.CreateObject("Scripting.FileSystemObject")
For Each f In fso.GetFolder(strfolderOld).Files
If fso.GetExtensionName(f) = "xls"
Then
set fsoForfile =
Createobject("Scripting.FileSystemObject")
set excel =
Createobject("Excel.Application")
msgbox f.name
excel.DisplayAlerts =
False
set wbk =
excel.workbooks.open(strfolderOld+"\"+f.name)
wbk.saveAs strfolderNew
+"\"+f.name
wbk.close
end if
next
'script ends
}