PPT How do I paste clipboard info to a specific location with VBA

Microsoft OFFICE


  • 1. playing a sound...
    How are you supposed to program to play a sound in VBA (Outlook2007)? -- veni, vidi, vici vba.
  • 2. MS Project 2010 + Trust Access to Visual Basic Project Object Mode
    Hi, I am trying to find "Trust access to the VBA project object model" option in Project 2010 but I can not find it. In other Office 2010 applications this options is under File => Options => Trust Center => Trust Center Settings => Macro Settings In Office 2000 to 2007 this option was available. Any tip where I can find it or how can I change it? Thanks in advance, Oliver
  • 3. Word 2010 64 bit and runtime error 429
    Hi to everybody. I've just installed on my Win7 64bit the new Office 2010 (the 64bit version). I've build a my COM server (a 32 bit dll file) that I regularly use in Word VBA til now with the previous Office realease (2007,2003 ecc). Now when I try to create an object with the CreateObject function I always get a runtime error 429. I suppose that 32bit dll is not compatible with 64bit Ms Word. Is there a way to use the mine 32 bit com server with Office 2010 64bit or the only solution is to downgrade to 32bit Office version? Thanks Davide Angeli
  • 4. Using VBA recursive folder search to collect folder security setti
    I've got a number of procedures that do recursive folder processing, so that part is covered. Using XL07 for this project. I'd like to create a list of the groups and individuals with security permissions (and what those permissions are) for each folder on a LAN. How do I access these properties via VBA? Example: Folder = "\\WRAC0921\Logistics\TestFolder" Where for each person or group, I need to collect (a) the group or person name (b) for each name, the true/false setting for read, read & execute, write, list folder contents, modify, and full control Thanks for any suggestions, Keith

PPT How do I paste clipboard info to a specific location with VBA

Postby tim.queen@pearson.com » Fri, 05 Mar 2004 04:47:22 GMT

I want paste specific ranges in an Excel spreadsheet to a 
powerpoint slide at a specific location on the slide. I 
have sucessfully pasted to a slide but I cannot figure out 
how to position the pasted item where I want it.

Similar Threads:

1.VBA Clipboard Cut & Paste from Excel to Outlook

An unusual one this one but please read on.

If I manually copy a range of cells from an Excel worksheet and then paste 
into a Draft email in Outlook (My Outlook 2003 uses HTML as draft format with 
Word as editor) the resulting pasted cells look fine - colors and formatting 
are maintained.

OK now to do it in VBA from Excel.

I copy the range of cells into Clipboard with :-

                Range(Cells(aa, 4), Cells(bb, 17)).Select

I then obtain the contents of Clipboard and place into a String variable 
with :-

                Set MyData = New DataObject
                strClip = MyData.GetText

I then create an Outloook object within VBA and build a Draft message using 
strClip as part of the Message body.

This all works OK and the Draft message is created but the resulting pasted 
range of cells in the Draft message does not look very good, the values are 
mis-aligned and wrapped around with any color formatting is lost. It does not 
give me the same pretty result as manually cutting and pasting the cells.

Does anyone know how I can preserve the formatting using the VBA method so 
that the resulting pasted cells looks as good as the manual method?


2.Excel - give users option to keep info in clipboard after pasting

3.Clipboard - "No" to Paste Info Later


I have a macro which opens a lot of documents (approx 90) 
as text files, extracts some data and copies this into 
excel for manipulation. The problem I have is that when 
the macro is closing each text file a large amount of data 
has already been copied to the clipboard.I get the 
following message: 

"There is a large amount of information on the Clipboard. 
Do you want to be able to paste this information to 
another program later?"

User intervention is required which I want to avoid.I 
always want to select "No" to this option, but at the 
moment I have to do it 90+ times. Is there some code I can 
insert to my macro to automatically select "No" each time?

Help gratefully received.


4.through vba code, copy full screen ppt slideshow image and paste into MS Word

I am trying to view a slide full screen and then print screen or
capture the screen
then change to Word
then paste the image into Word
return to ppt and repeat for the all slides
The code below gets started but the screenshot includes the vba editor
window and the paste part is not working.
I can't use any utilites like snagit on these PCs.
Option Explicit

Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal
  bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)

Private Const VK_SNAPSHOT = &H2C

Sub PrintScreen()
keybd_event VK_SNAPSHOT, 1, 0, 0
ReturnValue = Shell("winword.EXE", 1)  ' Run MS Word
SendKeys "^(V)"
End Sub

5.through vba code, copy full screen ppt slideshow image and paste into MS Word

6. VBA paste clipboard picture

7. copy and paste from excel to ppt with VBA

8. pasting excel charts into a ppt template using vba code

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 79 guest