PDA

View Full Version : xls to 2007 file type



danesrood
03-17-2010, 02:01 PM
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

Bob Phillips
03-17-2010, 03:09 PM
I don't think so, because the files are different formats.

danesrood
03-17-2010, 03:47 PM
xld

Fair enough.

Thank you for taking the time.

mdmackillop
03-18-2010, 06:46 AM
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.

Pinokkio
03-19-2010, 12:07 PM
Try this ?

http://www.vbaexpress.com/forum/showthread.php?t=30508