Excel data import - version question

[HOWARD MYERS]

We distribute a MS Access (97) application which references Excel's object
model to import various spreadsheet content. This works well up to and
including Excel 2003. In principle would there be any major problems using
the app. on a 2007 Excel file ? and if so how could this be overcome. The
Access app is being re-written in Access 2007, but this will be 6-9 months
down the line.

Regards

Howard Myers

[Nick Hodge]

Howard

It's really tough to say. There shouldn't be, apart from any references you
make to a workbook will need to be the new file extension, if you want to
use the large grid. In general they should be fine. Obviously if you have
any charts or shapes, these are still a little flaky in this Excel release,
but will improve for the next I'm sure.

Remember, if you have any simply Cells.Count type constructs you will have
to use Cells.CountLarge to use the full size of the grid. I would think few
problems.

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodge...@zen.co.ukANDTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk

"HOWARD MYERS" <hmy...@REMOVETHISBITbtinternet.com> wrote in message
news:_aOdne7rXObuYqvV...@bt.com...