VBA to Copy Excel cells (one at a time) text to Windows Clipboard so that the text can be Pasted into another application using Windows+V

[WFCompany]

I frequently need to copy the text from Excel spreadsheet's cells into other applications that do not use VBA.
The Customer's Name, Street Address, City, State, Phone Number, Email Address, etc. are all in different cells in the same worksheet.
The text then needs to be Pasted into another application using the Windows+V paste function.

I want to be able to create VBA code that will achieve the copying of each field into Windows Clipboard from one Button in Excel.
I have tried numerous methods, but the Windows Clipboard only contains blank values if more than one cell is selected and copied.

Please help!
Thanks

 

[Trevor G]

Welcome to the forum one way to explore is to look at using SendKeys method. You might end up exploring a time delay to switch to another app as well as shell command.

There are lots of sites that could help. Perhaps this site will give you a start point.

SendKeys statement (VBA)

Office VBA reference topic

learn.microsoft.com

 

[WFCompany]

Welcome to the forum one way to explore is to look at using SendKeys method. You might end up exploring a time delay to switch to another app as well as shell command.

There are lots of sites that could help. Perhaps this site will give you a start point.

SendKeys statement (VBA)

Office VBA reference topic

learn.microsoft.com

Thanks for the suggestion.
My first objective was to code the gathering of info from Excel - each field being a line in Windows+V.
The pasting into the other application could still be manual.
Your suggestion may allow me to do more than I had hoped. How are the Key values copied from Excel? How would this work for an application that is not part of Windows e.g. legacy software.

 

[WFCompany]

How can Ctrl+C or VBA command be used to create multiple lines when using Windows+V paste?