Posteriormente a mirar en diversos repositorios y sitios de internet al concluir hemos hallado la solución que te enseñaremos pronto.
Ejemplo: excel vba copiar a string al portapapeles
'VBA function to read and write text to the Windows clipboard.Function Clipboard$(Optional s$)Dim v: v = s 'Cast to variant for 64-bit VBA supportWith CreateObject("htmlfile")With.parentWindow.clipboardData
SelectCaseTrueCase Len(s):.setData "text", v
CaseElse: Clipboard =.getData("text")EndSelectEndWithEndWithEndFunction'--------------------------------------------------------------------'Three examples of copying text to the clipboard:
Clipboard "Excel Hero was here."
Clipboard var1 & vbLF & var2
Clipboard 123'To read text from the clipboard:
MsgBox Clipboard
'Note: This is a solution that does NOT use MS Forms 'nor the Win32 API. Instead it uses the Microsoft HTML Object Library 'which is fast and ubiquitous; and this solution respects line feeds.
¡Haz clic para puntuar esta entrada!
(Votos: 0 Promedio: 0)