Application.ActivePresentation.Slides.InsertFromFile unable to insert .pot file.

Question

I am using this line to insert a .pot file

Application.ActivePresentation.Slides.InsertFromFile(FilePath + sTemplateName, lSlideIndex, 1, 1)

but every time I am getting error couldn't access this file.

I am using absolute path to .pot file i.e.  "Local Disk (C):Applications:Microsoft Office 2011:Office:Media:Templates:Presentations:MCQ.pot".

Please let me know if there is any workaround.

Answer 1

Thanks all,

Issue resolved as VBA on MAC uses path like this "/Applications/XYZ/Templates/".

Answer 2

I suspect the parentheses in the name of the hard disk might be causing a problem. Rename the hard drive without the parentheses and see if that fixes the problem.

Answer 3

Hi David,

Thanks for reply :)

The same code is working fine if I have the PPT file saved on the same path where my .pot files are and I am using relative path to these .pot files. Relative path is "Templates:MCQ.pot".

And even if I copy these .pot files to MSOffice template folder and use relative path it works fine.

But if I reference these .pot files using absolute path then again its not working.

Application.ActivePresentation.Slides.InsertFromFile(:Templates:MCQ.pot", lSlideIndex, 1, 1)

This line of code working fine if I have relative path and the ppt is saved on the same location where Template folder is.

Answer 4

Hmm. That seems odd. Generally, a template doesn't have any slides to insert. The template file would just have a slide design. Could that be the error you are getting?

David Marcovitz

Author of Powerful PowerPoint for Educators

http://www.PowerfulPowerPoint.com/