Inserting the Power Point template in the Macro

[saraf]

Hi All,

I am trying to export the Excel contents into a Power point with a macro.Can I insert the ppt template in the macro so that every time I run the macro it shud automatically use that template but no the default or is there any way to define the layout of the template in the macro which prepares the template on the fly and inserts the excel contents when I run the macro.

Thanks,
Saraf

 

[Glory]

Really simple starter, go Tools->References and click the checkbox next to Powerpoint... then Dim a new powerpoint document (whatever the object name is) to get intellisense working and show you various methods available to new powerpoint documents.

 

[saraf]

Hi Glory,

Thank you very much, I have added the Power point in the references.
can you pls provide me the line to insert into my code as I am new to VB.


Saraf

 

[Glory]

Try checking here. I've never worked with Powerpoint using VBA. I wouldn't worry about the template if I were you. I'd just worry about creating a new document, saving it as a PPT file, and adding items/slides.

 

[saraf]

Ty very much Glory.