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
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_hodgeTAKETHISOUT@zen.co.ukANDTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "HOWARD MYERS" wrote in message news:_aOdne7rXObuYqvVnZ2dneKdnZydnZ2d@bt.com... > 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 >
