>>>>>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
>
>I had tried manually saving as 95 format - but must have been doing something wrong because my error did not go away. I tried it again today and it worked. Go figure.
>
>At any rate, I found your post on how to do this in code and that worked too (no surprise to you I'm sure).
>
>Thanks a bunch............Rich
You're welcome.
Now let's wait see what Office 2007 SP1 will break later this month...
Pertti