From access 2003 to access 2007 issues with a module

[MonicaMe]

Hi I'm completely new of this forum and I'm looking for a solution on an access module I use now on 2003 version but that does not work in 2007.

each time I try to run it it gives me a compile error "method or data member not found"

Set OggettoGrafico = PrimaSlide.Shape.AddOLEObject(80, 80, 560, 400, "Excel.sheet", , msoFalse, , , , msoFalse)

and .shape is highlighted.

The complete module open a query create a predefined exce chart and put it in a powerpoint slide

is it possible for you to give me a suggestion? did something changed from 2003 to 2007? I'm not a programmer I'm only an "upgraded" user and an help from your side will be highly appreciated

Thanks!

[JoeM]

I am guessing that the database may use a special Reference Library that needs to be selected in Access 2007 also.

The easiest way to open the database where it does work, then go to the VB Editor, go to the Tools menu and select References. Note all the different references that are selected.
Then go to the computer you are trying to run it on in Access 2007, and go to ther same place and note all the references selected. If any are missing, go down the list, find it, and select it (note the version number may be higher, but it should essentially have the same name).

[MonicaMe]

Hi Joe,
Thanks!!!!!!!!!
I checked and now it works, many many thanks for your help

[JoeM]

Your welcome. Glad it worked out for you!

You can mark the thread as solved as described here: https://www.accessforums.net/forum-s...lved-1828.html