Hi Naomi,
>Did you try checking if Open method has an extra parameter for the format?
The format parameter in Open only refers to the delimiter character for text file import. There's a converter parameter where you can pass the index from the FileConverter collection. However, my Excel 2003 doesn't list any converter in this collection (it's NULL) even though it converts XLSM/XLSX files just fine.
--
Christof