Dear All
Is there a way of converting a directory full of xls files in to the appropriate 2007 file type without having to open each one individually.
Any help would be most appreciated.
Danesrood
Dear All
Is there a way of converting a directory full of xls files in to the appropriate 2007 file type without having to open each one individually.
Any help would be most appreciated.
Danesrood
I don't think so, because the files are different formats.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
xld
Fair enough.
Thank you for taking the time.
You could create a macro to carry out the task, using Open/SaveAs commands, unless you were trying to avoid opening in this sense also.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'