clipboard

  1. J

    Dropbox and Excel

    Hello First 'Seasons Greetings' to all you users. I have a spreadsheet with the root path for over 1,000 documents that get sent out via a mail merge. The problem is that although this system works perfectly well, if the document contains errors that recipient will always have a hard copy of...
  2. S

    VBA help to copy text to clipboard

    Hello, Here is the Macro that I am using Sub Selected_to_Comma_Separated() Dim MyRange As Range Dim NewRange As Range Dim arr Dim clip As MSForms.DataObject For Each MyRange In Selection If MyRange.Value <> "" Then MyRange.Value = Chr(39) &...
  3. P

    VBA Speed up copy/paste by not using clipboard HELP

    Hi, I am trying to speed up a macro i have which does lots of copy paste functions after some calculations have been completed. I tried this: OutputRow = 3 + ((Modelpoint - 1) * 126) Sheets("ENGINE").Range("A348:DZ473").Value = Sheets("Output").Cells(OutputRow, 1).Value Modelpoint...
  4. H

    Error with Excel Clipboard? Help!

    Hello Could someone help me fix the problem. Let's assume: 1. I copy text from excel 2. Paste it to Notepad (or other programs) Until here, all are OK. Next.. 1. I copy text from Notepad (different content / text with Excel) 2. Paste it to Excel, but when I do, Excel paste the content from...
  5. S

    use vba to put address from open win explorer instance into the clipboard

    I am working on Windows 7 and Office 2013. I have an open instance of windows explorer that has been navigated to a folder. From excel vba I would like to load that win explorer address into the clipboard. I do not have a clue how to do this. Can anyone assist me?
  6. E

    MACRO: Saving clipboard data to a file

    Hey everyone, I am trying to build a log that will help my team do their jobs more efficiently. I've built a UserForm that correctly logs the information entered into it. I think I've come to my knowledge limit. What i need now, is when the user clicks "add" to submit the data, for excel to...
  7. R

    Stuck on a simple IsNumeric Test: If Contents of the Clipboard is Numeric Then Proceed Else Exit Sub

    I have found ways of testing the contents of the clipboard for all kinds of things, but apparently there's no easy way of testing the clipboard for numeric values. Basically the user will have something in the clipboard, and if it's not a digit, they made a mistake. My code will error out if...
  8. H

    Is it possible to assign InkPicture background image from the clipboard?

    I have a signature form on a tablet that takes the input strokes and then displays them as a picture object (as opposed to an ActiveX shape, which I try to avoid because they can drastically slow down the underlying code). A second technician can add his signature by opening the form, which...
  9. M

    Ms excel clipboard not working

    :confused:Hi guys, I am having a problem when I copy set of cells. I am copying a filtered set of cell in a worksheet and then unfilter the worksheet to delete the original set of cells. Then I will paste the filtered set of cells that I was supposed to get from the clipboard. Thing is...
  10. B

    Need Macro to paste from clipboard on open

    Hello all, I am attempting to create a macro that will paste to cell E3 the latest value copied when opening the workbook depending on it's value. I need it to only paste the value if it is a 10 digit phone number. For example: "1231231234". It would be ideal if it were to remove dashes when...
  11. A

    VBA code to copy ActiveSheet.name to the Clipboard?

    Excel friends, this should be an easy one: What is the code to copy the ActiveSheet.name to the clipboard? So, I can paste it anywhere I want outside the Excel workbook. Any help is appreciated. Thanks!
  12. C

    VBA syntax to make a selection in a popup window when closing a file...

    I've recorded a small macro that opens a text file, copies a specified range of values, closes the file, and finally pastes the values in my excel spread sheet... problem I'm running into is when the macro goes to close the file, a pop up window comes up that asks if I want to keep all of the...
  13. F

    vba clipboard.getText to textarea Website

    Hi guys I managed to copy excel data to Clipboard in Csv format: Sub CSVclipboard() Dim myRange As Range Dim strTemp1 As String Dim objDataObject As MSForms.DataObject ' require ref to MSForms library Set objDataObject = New MSForms.DataObject On Error Resume Next Set myRange =...
  14. M

    Excel Windows 2010. Commands disappeared

    Hi. This is my first post. In Excel Windows 2010, in the left hand side, in the Clipboard. There use to be the signs and the commands together. For example: picture of scissors and the word Cut; sheets and the word Copy. Now I just have the icons, and not the words. How can I fix it? Regards...
  15. B

    Paste a copied image into a Picture Box?

    Hi all, I'm trying to create a situation where when someone clicks on an image box, it pastes their clipboard image into the imagebox. The image is found online. Unfortunately, I have no idea how this is possible. After much googling, i came across the "Pastepicture.xls" item made in 2000, but...
  16. W

    Copy Word into Excel and clear Clipboard message

    Could not get the Word App to quit without the "Large amount of data in clipboard" dialog and Word has no way to avoid it, so sendkeys seemed the easy way out ... Anyone know a more elegant method? Sub Word_to_Excel() ' Dim wApp As Word.Application, gdoc As String ' Set wApp =...
  17. F

    How to paste then nth item on the Office Clipboard?

    Hi - After a fair amount of research on various methods of accessing the clipboard, I'm drawing a blank on this. Say that I've copied several things to the Office Clipboard and now I want VBA to paste the first five items into a worksheet -- how do I do that? I've run across other situations...
  18. J

    Clearing the ClipBoard between Copies

    I have code that is copying data from two different programs and ultimately pasting it back into excel. When I copy from excel and paste the data into my other program, known in VBA as "session", then I copy from the relfection session and try to paste it to excel, some times it retains the...
  19. L

    Paste Image In Textbox

    I need to control a reports formatting. Can the following code be altered to paste screenshots from the clipboard rather than text? Private Sub CommandButton1_Click() Dim CB As New DataObject On Error Resume Next CB.GetFromClipboard...
  20. M

    Macro for copying the value of a cell to the clipboard

    Hi I need a macro that copyis the value of a cell, with a formula, to the clipboard. Say, A1 contains: "=B1+1" B1 contains: "10" The macro should be able to copy the value of A1 so the clipboard contains "11". Martin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top