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