Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | Printer problems

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Register FAQ Community Calendar

Excel VB Code to automatically assign title in PowerPoint
Reply
 
Thread Tools
Old 24-09-2008, 12:08   #1
absthechatter
Inactive
 
Join Date: Dec 2004
Posts: 310
absthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really nice
Excel VB Code to automatically assign title in PowerPoint

I have written a Macro that copies a chart from Excel, creates a new slide in Powerpoint adds a blank title ("Click to add title") to the top and pastes the chart as a picture. What I really want to do is get the Macro to add the actual title I want, this will be different for each chart.
The code for title I have at moment is;

SlideCount = PPPres.Slides.Count
Set PPSlide = PPPres.Slides.Add(SlideCount + 1, ppLayoutTitleOnly)
PPApp.ActiveWindow.View.GotoSlide PPSlide.SlideIndex

Any idea what I add to get it to write title??

Any help would be much appreciated.

Abs
absthechatter is offline   Reply With Quote
Advertisement
Old 27-09-2008, 20:46   #2
brundles
Inactive
 
Join Date: Jan 2006
Location: Berkshire
Posts: 1,266
brundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of societybrundles is a pillar of society
Re: Excel VB Code to automatically assign title in PowerPoint

I've not tried anything with Powerpoint from Excel, but Ozgrid tends to have some VBA gurus hanging around most of the time.
brundles is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:19.


Server: osmium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum