 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2007PowerPoint-tags in Excel
Hi folks who know the use of tags in PowerPoint, I have presentations in PowerPoint using MSGraph 2003 and here's what I want to do via VBA. This part I understand how to do: Get the data from the MSGraph datasheet into an Excel worksheet. I want to create the chart in XL using a Library of charts. That I can do as well. I'd like to automatically re-insert the XL chart back into PPT on correct page and correct size. I suppose I could write the appropriate values to the Excel worksheet and go delete the original chart in PPT and size correctly. Anyone have any better ideas? Is there a tag-like functiionality in XL like there is in PPT? Brian Reilly, PowerPoint MVP Brian - I'm not too familiar with tags, except for being jealous that you guys got em and we ain't. I would follow the same scheme that you're describing. Don't delete the old chart until you know the new one has taken. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Hi folks who know the use of tags in PowerPoint, > [quoted text clipped - 14 lines] > > Brian Reilly, PowerPoint MVP Jon, Thanks for the advice. Yes tags are wonderful. I've almost stopped using shape names in favor of tags which store two properties, a name and a value. And you can literally have thousands of them attached to a shape. It's sort of like have two XL columns to store variables in like Top 42 Brian Reilly, PowerPoint MVP >Brian - > [quoted text clipped - 27 lines] >> >> Brian Reilly, PowerPoint MVP Do you still have these with the "new improved" Office 2007 shapes? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > Jon, > Thanks for the advice. [quoted text clipped - 38 lines] >>> >>> Brian Reilly, PowerPoint MVP Jon, Yes, a shape is a shape even in Office 2007. Other stuff has changed (g) but they didn't delete any of the old stuff. Check out the PPTFAQ.com page and search on tags for more information. They are really good things to know about if you are coding in PPT. Brian Reilly, PowerPoint MVP >Do you still have these with the "new improved" Office 2007 shapes? > [quoted text clipped - 47 lines] >>>> >>>> Brian Reilly, PowerPoint MVP |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.