Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VB Code
Hi
I have created a excel vb code to copy the pivots from excel to powerpoint slide. The problem iam facing is, unable to create a Textbox in the same active powerpoint slide. Could you please help me to write an excel vb code in excel, so that i can add a text box to the active window powerpoint slide. Below is the code i tried in excel macro, while running its asking for an object. Dim PPApp As PowerPoint.Application Dim PPPres As PowerPoint.Presentation Dim PPSlide As PowerPoint.Slide Dim slidecount As Long Dim ans Dim answer As String Dim RangetoPaste As Range Dim PPShape As Shape ActiveWindow.Selection.SlideRange.Shapes.AddTextbo xmsoTextOrientationHorizontal, 50, 50, 400, 24).Select ActiveWindow.Selection.ShapeRange.TextFrame.Wordwr ap |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming | |||
do anybody have a sample code for executing excel macro from vb code?<eom | Excel Programming | |||
stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming | |||
Excel XP VBA code to search all macro code in Excel module for specific search string criteria | Excel Programming |