>>>>>Hi
>>>>>
>>>>>I have a problem with users trying to import spreadsheets saved in the wrong version of excel.
>>>>>
>>>>>Is there any way I can detect the version of excel the spreadsheet has been saved in so I can retunr a bettre error/warning message.
>>>>>
>>>>>Thanks
>>>>>
>>>>>Nick
>>>>
>>>>
>>>>
http://www.foxite.com/archives/0000153776.htm>>>>
>>>>Cetin
>>>
>>>Thanks Cetin
>>>
>>>at the moment I have gone for automating opening the spreadsheet and saving it in a format suitable for
>>>
>>>IMPORT from lcFilename TYPE xls
>>
>>IMHo that is one of the worst choices but if it works for you then no problem.
>>Cetin
>
>Well I have two things to say to that.
>
>1 why do you think its the worst choice ?
>
>2. This is maintenance only system where I have very limited time available to fix many problems and I need a solution that maps on to whats already there as closely as possible.So what would you do in that position ?
>
>TIA
1) Import from always had problems. The known versions that import can use have additional problems like rowcount.
2) I would use the coding that gave link to (actually that code is the result of such necessities).
Cetin