clipboard

I know the title probably sounds weird, but I'm not sure how else to phrase it! If I copy a cell in Excel, and then copy something else from a different application, if I try to paste in Excel it will paste the contents of the cell I copied previously instead of the thing I copied in the other...

Hello, I am trying to do something like: Range(“B1").Value = Range(“A1").Value I can get this to work, but I cannot get it to work across multiple workbooks. When I declare the workbooks and the sheets I end up getting Excel error 438. Any Idea why? How can I get around this?

Hello everyone, I am having a little really nasty issue with VBA where I cannot find any solution at all. I am getting this infamous warning message where it displays "We couldn't free up space on the clipboard. Another program might be using it right now". VBA gets into debugging mode and...

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...

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) &...

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...

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...

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?

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...

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...

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...

: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...

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...

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!

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...

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 =...

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...

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...

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 =...

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...