| Home > Forum Home > Developing and Auditing Analytical Models > Excel and Notepad: how avoid additional inverted commas after copy and paste? | Share |
Excel and Notepad: how avoid additional inverted commas after copy and paste?
Excel Help for Excel And Notepad: How Avoid Additional Inverted Commas After Copy And Paste? in Developing and Auditing Analytical Models
| Forum Topic | Post Reply Login |
Excel And Notepad: How Avoid Additional Inverted Commas After Copy And Paste? | Rate this: (3/5 from 1 vote) |
 | Hi, If I write a multi-line text in a cell (then go down with alt+enter) and after copy the cell pasting on Notepad, it display before inverted commas and after textual content. Instead, if I select directly the content from the formula bar, it isn't happen. Do exist a way for copy and paste directly from the cell without select from the formula bar? Maybe with a macro? Thank Marco __________________ http://www.idee-regalo.biz/catalogo-stereogrammi-3.html http://www.ghisirds.it/ http://scuo.la/ http://www.righettofabrizio.com/pantografo-taglio-plasma.html | |
| Posted by ghisirds on | ||
| Replies - Displaying 1 to 2 of 2 | Order Replies By: Most recent | Chronological | Highest Rated |
| Rate this: (3/5 from 1 vote) I solved the problem and it is work. Sub TestMacro() Dim objClip As DataObject ' Microsoft Forms 2.0 Object Library ' needs to be selected as a Reference (on the VBA Tools menu) Dim strTmp As String Set objClip = New DataObject strTmp = Replace(ActiveCell.Value, Chr(10), vbCrLf) objClip.SetText strTmp objClip.PutInClipboard Set objClip = Nothing End Sub best regards. |
| Posted by ghisirds on |
 | Rate this: (3/5 from 1 vote)
|
| Excel Business Forums Administrator | |
| Posted by Excel Helper on |
| Displaying page 1 of 1 |
| Find relevant Excel templates and add-ins for Excel and Notepad: how avoid additional inverted commas after copy and paste? in the Excel Business Solutions Directory |