clipboard

Hi Im wanting a macro to paste whatever is in the windows clipboard into a sheet Do i need to use DataObj or is there an easier way? Like replicate ctrl-v being pressed Any help appreciated

I am trying to write a macro that selects a named range of cells, copies them to the clipboard, asks the user to pick a cell for pasting and after the selection is made, then paste in the selected cell. This may be redundant below but I will show the steps more in detail. Step one: Select...

Hi there, I've been having some trouble with the following script. The aim is to copy an account number from the excel spreadsheet and paste it into reflections and then submit and confirm (enter, f9). After that I need to copy some of the data from reflections and paste it into the...

I'm copying some data from various places on spreadsheet into a text string on the clipboard, and wanting to manually paste into both a table in Word, and a table in an Outlook email. The problem is that the spcl character vbTab does not seem to be recognised by either Word or Outlook in the...

I have a macro that copies certain information to the clipboard which works perfectly. This is where I need help. I need to be able to copy/paste the clipboard to a text file and it would be better if I am prompted for a location/directory in which to create the text file and for a name for...

I use auto refresh connections, set to every minute. It seems to clear my clipboard so if I copy something and a refresh occurs I can't then paste. Is there a way around this?

Hi, I have just finished an excel macro that involves copying a sheet and pasting it into another. I had the macro then close the workbook sheet but an excel message "there is a large amount of information on the clipboard...." prevents the macro from finishing, Clicking "no" allows it to...

Hi, This may be a little difficult to explain, so please bear with me. I recently switched from Excel 2003 to 2013, and have noticed that 2013 seems to handle image resizing and/or clipboard output a little different to 2003. In Excel 2003, I was able to paste an image (screen shot) from the...

I daily use a macro that puts excel data on the clipboard and also generates an outlook page (the mail adres is available in this outlook document) If I manually paste the clipboard data into the outlook, it works fine. I am looking for a VBA code to perform this action, it would make the macro...

On a different thread of mine, a very helpful member by the name of @Eric W helped me out with a particular macro, to solve a bug type issue I was having. This macro got me thinking of another possible use for it. 1.) I am looking to be able to select a cell or multiple cells that contain text...

Hi I have an item in Clipboard, then I select multiple cells and want to paste into those selected cells using Clipboard however it only paste in one of those cells. Is there a way to paste to all selected cells using Clipboard. Thanks Jon

Hi All I thought I would share a small solution to a problem that has niggled me for a while. I hope it helps someone and perhaps indeed there is a better approach? At the very least I know I can come back here in the future should I need it again. :) I want to stop users from using paste...

I am working on a Project where the task is to populate a list of pdf-files (in sheet "Get files") and then open each pdf-file, copy all text and paste this text into a column of another Excel sheet ("ExtractedText") Everything Works fine except for the final step of pasting it from clipboard...

Hello I use some code to copy a cell value to the clipboard. If I copied back the clipboard to NotePad, the proper value is copied If I tried to copy the value to an Excel cell, I'm getting an error Extract of the code Note: - All variables had been previously define. Only the clipboard...

Hello, everyone. I am someone of a novice to Excel but know enough to get by. I am putting together a spread sheet where I need to click on a button or cell that will automatically copy a URL or text into the clipboard of the computer. In the office, I work at we do a lot of copy pasting and it...

Dear all, I am new here, thanks for having me : ) I have below module code that inserts rows from a second (Formats) sheet on button click. The rows are pre-format, including design and formulas. Before the row or the multiple rows (depending on selection) are inserted, the macro copies the...

Ugh its so irritating that it holds onto the clipboard data unless I clear it manually. I can't stand it. I don't know why it is doing this all of a sudden other than there seem to be dozens of periodic changes that happen now that everything is cloud-based. Anyway, if someone can please please...

I am trying to copy a range of cells into a the windows clipboard so I can paste it onto another workbook. Preferably I would like to be able to copy the cell borders as well. This is what I have so far but it doesn't work. Dim wbname As String Dim Clipboard As MSForms.DataObject Set 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?