clipboard

So, I currently have a checkbox that hides rows based on if the cell has data. I want to be able to now have a button (inserted Shape) to copy cells L2:P40 but remove rows that cells M4:M38 do not have any data. I want to copy this out to the clipboard as a grid with all the formatting Here...

Is there any way to get information for data in clipboard, before pasting into Excel. This could be things like: - First element value - Size of range if it's a table Is there any information to get started on this? Not really sure what the clipboard looks like

Hi, I would like to have a code that copies a string to the windows clipboard using VBA. So i can paste the clipboard to other software then excel. My code is now the following: Dim strText As String strText = FilePath With New DataObject .SetText strText...

Good morning, I am trying to figure out how to use VBA to put a message with text and clickable URLs into the clipboard. To further complicate matters, I use a PutInClipboard workaround (which works fine) because PutInClipboard does not work for me unless my file explorer is closed. Below is...

No luck with Sendkeys, so I've tried the code below, which sort of works, except that the Windows clilpboard flashes up then immediately disappears. The Const VK_LMENU &H5B appears to work (I've tried and discarded &HA4, because when I call this function in the VBE with &HA4, it just brings up...

Hi all - I run VBA macros all the time that take 20-30 minutes in some cases - I generally run them on a secondary machine, not my primary machine. However one issue I've had is that since newer 'remote' solutions like the windows 10 version of Remote Desktop and VMWare Horizon/Blast share the...

Everyone is familiar with the "Paste Column Widths" command that will take information from the clipboard and use it to transfer the column widths of a copied range to another range without including the actual data from the cells that were copied. Thus, it seems to me that when a range of...

I am running multiple sessions of Excel with macros running and find that I am unable to effectively use "Copy/Paste" in another workbook while a macro is running in another session that is using copy and paste as part of its routine. Is there any way to have isolated uses of the clipboard for...

Hi. I use this code in Excel vba: Dim wdApp As Word.Application wdApp.Documents.Open "E:\Download\planeringsmote.doc" wdApp.Documents(1).InlineShapes(2).Range.Copy wdApp.Documents.Close wdApp.Quit The problem is that Word don't close because Word popup a messagesbox that ask...

This macro/VAB/Sub... needs to be able to paste data into a single excel cell. The copied data may be one word or multiple paragraphs from a word document. Either way it needs to be pasted into one single cell. The code needs to pick up from this point: ' Paste info from clipboard starting at...

I have a spreadsheet with multiple queries linked to it. When the user wishes to refresh the queries, they press a "refresh all" button I have provided to them which just saves them the time of having to utilize the built-in menu options simply because they never remember where to find it. The...

I want to automatize the following procedure: I want to attach an email after sending it to a document in SAP, but as soon as the "select Files:" windows appear my code is blocked from continuing bc this window belongs not to the SAP application itself (I don't know if these are the correct...

I want to copy a variable to the Clipboard and I have used this code in the past and it worked. Now it just returns ?? Any help would be appreciated. Sub test() 'Microsoft Forms 2.0 Object Library is referenced Dim MyData As DataObject Dim strClip As String strClip = Range("J" &...

I've got this code attached to a button on my QAT. it copies the file path, filename, sheetname and selection range to the clipboard so that it can be quickly pasted into the sheet or emails. It mostly works fine. However when File Explorer is open, it usually just puts 2 ascii 10's into the...

Hi, I am trying to cut a range in workbook1 and paste it using a PasteSpecial macro in Workbook2, but I am getting an error. The PasteSpecial macro works fine when I copy the range instead of cutting it. In macro 1, I use the following code to cut a range into the clipboard: Range(Temp...

I have Excel 2019 (16.29.1) I do not see an option to insert a userform or enable object library 2.0. Is there a way in Excel for Mac to setup a macro to copy cell value to clipboard? Thanks for the help!

After troubleshooting why my Excel 2007 seemed to be unnaturally sluggish, especially with copy/paste functions, I traced the problem to Microsoft's "Mouse Without Borders" app (which lets you share a single mouse/keyboard with two different computers, and glide from one desktop onto the other...

Hello guys, i have a file that i only want to be editable by user forms. For that result i protect the sheet and unprotect it only when running the macro. But users are still able to browse through the data, copy it. Most of the time they will edit specific places by copying and searching via...

? Cross-post!I have «Microsoft Office 365 2019». ? I have <code style="margin: 0px; padding: 1px 5px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation...

Trying to copy a column and paste using the clipboard on the Home ribbon. When I do this it usually converts the text values to numbers (for numbers that I copied and pasted externally) Run-time error: 1004 Paste method of worksheet class failed Sheets("Sheet2").Select Range("K2").Select...