Program works in Access 2003 and not in 2007 - Help

G

Gary

I have been using Office 2003 (Access 2003, Power Point 2003, Visio 2003, etc).

I have the following VBA Code in Access 2003 which copies an OLE Object and
paste it into a new slide. This is my VBA Code:

Set oPPT = NewPowerPoint.Application
Set oPres = oPPT.Presentations.Add(True)

Do Until T.EOF
Forms![GemPPT]![OLEFile].Action = acOLECopy
oPres.Slides.Add (oPres.Slides.Count+1, ppLayoutBlank).Shapes.Paste

The above code worked in Office 2003 and in Office 2007 sp2, it doesn't
always work. But, only once in a while it does work with the same data.

I am undable to do a "Macro Recorder" because that has been deleted from 2007.

I would appreciate how to do it (if possible).

Can someone please help me here !!!!

Thank You,

Gary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top