>>>>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