>>>Is it by any chance in Excel 2007 format?
>>I don't know. Is there any way to examine the file to find out? Either some property I can find out in Excel or via looking at some specific bytes in the file.?
>>
>>>If yes, then this problem was already discussed here and IMPORT function is not going to work.
>>
>>Ouch.
>>
>>Thanks a bunch for responding.
>>
>
>Rich,
>
>Please check this thread
Checking the version of an Excel File Thread #
1260311 and also thread referenced there.
You can also check Thread #
1272524 to see how you can save Excel file to Excel 95 format programmatically through OLE Automation. I do this into a dedicated temporary XLS file as an intermediate step every time I import spreadsheets now using a simple ImportXLS5(
) -function I wrote.
Pertti