Help - VBA Code Works In 2003 and not in 2007

[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

 

[Kevin L.]

Hello,

We are having the same problem I used the code from here
'http://support.microsoft.com/kb/222708/EN-US/ as a starter. It was working
fine then boom last week (7/22/09) we get the "Microsoft Office is waiting
for another application to complete an OLE action." We are running Office
2007 12.0.6.6504.5001 SP2 MSO (12.0.6425.1000) and on my other machine is
Office 2003 (11.8307.8221 SP3) Both are running Windows XP SP3. Both Office
11 and 12 are now bombing out and we are unable to update our links at all.
Even when we go to open the link window manually it will take 10 minutes just
for the window to pop up and then over an hour to change the links from
automatic to manual. I am suspicious of a hotfix/update. Sorry I do not have
solution, but I sure would like to hear a solution
Kevin.