PC Review


Reply
Thread Tools Rate Thread

Copy from Excel to Powerpoint using VBA

 
 
New Member
Join Date: Apr 2010
Posts: 1
 
      20th Apr 2010
Hello all, I am new to using VBA and this is probably a simple solution. I am trying to copy a cell from an excel file that opens in the macro and then paste it to an existing textbox in PowerPoint. I can get the macro all the way to opening slide 2 of PowerPoint and paste to a new textbox but then I am lost of how to get it to paste to a specific textbox. Any help would be appreciated!!

Sub Macro3()
'
' Macro3 Macro
'
'
Dim PPT As PowerPoint.Application
Dim PPPres As PowerPoint.Presentation


Set PPT = New PowerPoint.Application
PPT.Visible = True
PPT.Presentations.Open Filename:="C:\NSS Presale\Test Customer Serving Plan Template.pptm"

myFile = Application.GetOpenFilename()
Workbooks.Open myFile
Range("E24").Select
Selection.Copy

PPT.Activate
With PPT.ActiveWindow
.View.GotoSlide Index:=2
.View.Paste
End With

End Sub
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy from Excel into Powerpoint JenL Microsoft Powerpoint 1 22nd Feb 2008 09:37 PM
copy chart from Excel to Powerpoint =?Utf-8?B?SG9mZnBlcnNvbg==?= Microsoft Excel Misc 1 7th Dec 2005 12:13 AM
Copy from Excel into Powerpoint - picture changes Andrew Wood Microsoft Powerpoint 2 31st Jul 2004 11:18 AM
Re: excel copy to powerpoint Jon Peltier Microsoft Excel Misc 0 19th Sep 2003 09:57 PM
excel copy to powerpoint ccw Microsoft Excel Misc 0 19th Sep 2003 07:12 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:21 AM.