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
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