>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.
Thanks a lot, Christof. Really glad to see you here again. How is the conference?
If it's not broken, fix it until it is.
My Blog