Access and Excel - version question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

HOWARD MYERS - 24 May 2008 14:49 GMT

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

Reply to this Message

Shane Devenshire - 24 May 2008 21:21 GMT

Hi Howard,

You will need to test it with your app. No one here can guess exactly what
is in that app and therefore won't be able to tell you if there is going to
be a problem. In theory things should work with minor modification,
however, there is no guarantee.

Cheers,
Shane Devenshire
Microsoft Excel MVP

> We distribute a MS Access (97) application which references Excel's object
> model to import various spreadsheet content. This works well up to and
[quoted text clipped - 6 lines]
>
> Howard Myers

Reply to this Message