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