How can i convert a lot of '97 excel file to '95. I look for other solution as File - Save As.
+2
A:
Record a macro and expand the generated VBA code as needed, for instance to open all .xls files in a given folder and convert them one after another, etc. Might not give the best possible performance but development time should be around 1 hour, maybe less.
tijmenvdk
2010-07-15 19:49:00
Similar to an answer I gave recently for converting Word files to PDF. There's code in the link: http://superuser.com/questions/163217/is-there-a-free-batch-doc-to-pdf-converter-out-there/163221#163221
Mark Ransom
2010-07-15 19:52:35
+1
A:
Loop through the files and use the SaveAs method combined with the fileformat of your choosing.
buckbova
2010-07-15 20:06:17
A:
hi, i found this apple script:
set theFolder to choose folder with prompt "Choose the folder that contains your Excel files"
tell application "Finder" to set theFiles to (files of theFolder)
set fileCount to count theFiles
repeat with i from 1 to fileCount
set fName to text 1 thru -5 of ((name of item i of theFiles) as text)
if ((name of item i of theFiles) as text) ends with ".xls" then
set tName to (theFolder as text) & fName & ".xls"
tell application "Microsoft Excel"
activate
open (item i of theFiles) as text
tell active workbook
save workbook as filename tName file format Excel7 file format with overwrite
end tell
close active workbook without saving
end tell
end if
end repeat
Kukoda János
2010-07-15 22:53:31