 |
 | 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 / General PowerPoint Questions / July 2007vba msgraph changing font
Hey all, I am grabbing data from XL and inserting into existing PPT embedded sheets. The problems is that some of the numbers are bolded in XL and so they are bolded when they get inserted into the MSGraph datasheet header column. How can I "unbold" them? I have tried: oGraph = PWB.OLEFormat.Object oGraph.Application.datasheet.Range(oPPTCELL).Value = oVALUE oGraph.Application.datasheet.Range(oPPTHEADERCELL).Value = oHEADER oGraph.Application.datasheet.Range(oPPTHEADERCELL).Font.Bold=False but I get an error? Thanks in advance, Lance > Hey all, > > I am grabbing data from XL and inserting into existing PPT embedded sheets. I'm not sure what "PPT embedded sheets" are. Datasheets that're part of an MSGraph chart, I'd guess. Can you confirm that? Thanks. > The problems is that some of the numbers are bolded in XL and so they are > bolded when they get inserted into the MSGraph datasheet header column. [quoted text clipped - 7 lines] > > but I get an error? On what line of code and what is the exact text of the error message? ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ > I'm not sure what "PPT embedded sheets" are. Datasheets that're part of an > MSGraph chart, I'd guess. Can you confirm that? Thanks. Yes, datasheets that are part of an MSGraph is what I mean. This is the line where I get the error >> oGraph.Application.datasheet.Range(oPPTHEADERCELL).Font.Bold=False > On what line of code and what is the exact text of the error message? > [quoted text clipped - 3 lines] > PPTools: www.pptools.com > ================================================ > > I'm not sure what "PPT embedded sheets" are. Datasheets that're part of an > > MSGraph chart, I'd guess. Can you confirm that? Thanks. [quoted text clipped - 6 lines] > > > On what line of code and what is the exact text of the error message? It's a good idea to leave previous posts quoted, within limits, so we can refer back to the code more easily. ========= you have =================== oGraph = PWB.OLEFormat.Object oGraph.Application.datasheet.Range(oPPTCELL).Value = oVALUE oGraph.Application.datasheet.Range(oPPTHEADERCELL).Value = oHEADER oGraph.Application.datasheet.Range(oPPTHEADERCELL).Font.Bold=False ====================================== It seems that you can only format the font for the entire data table, not for portions of the datasheet. I haven't tested this but try: oGraph.Application.Datasheet.Font.Bold = False ----------------------------------------- Steve Rindsberg, PPT MVP PPT FAQ: www.pptfaq.com PPTools: www.pptools.com ================================================ |
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
|
©2008 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.