Import module into Powerpoint file using excel vba

[lpking2005]

hi all,

Does anyone know how to import modules which are saved on the computer into a opened powerpoint presentation?

I have succeeded in doing this with importing into other excel files and i am trying to modify that code.

Everything works up until it trys to import the modules.

Here is my current code:

'Open the presentation


Dim PPT As PowerPoint.Application
Set PPT = New PowerPoint.Application
PPT.Visible = True
    
    PPT.Presentations.Open filepath
    


'Set filepath for modules
    ModulePath = "\\ukashntapps24v\qwb_pro\master\"


'Set Each of the Modules Filenames
    routine = "Full_Routine.bas"
    status = "Status.bas"
    revision = "Revision.bas"
    
'import modules
    
    PPT.ActivePresentation.VBProject.VBComponents.Import ModulePath & routine
    PPT.ActivePresentation.VBProject.VBComponents.Import ModulePath & status
    PPT.ActivePresentation.VBProject.VBComponents.Import ModulePath & revision

Any help would be greatly appreciated.
Thank you.

 

[Andrew Poulsom]

In what way doesn't it work?

 

[lpking2005]

Sorry, I have just found out the error.

It was the macro security in powerpoint, the "Trust Access to Visual Basic Project" was not checked.