Can you copy from the formula bar (even if you have to convert a formula to
value before the copy)?
Another suggestion saved from a previous post:
I used the PutInClipboard routine that Chip Pearson has:
http://www.cpearson.com/excel/clipboard.htm
With this sub:
Option Explicit
Sub testme()
Dim MyDataObj As DataObject
Set MyDataObj = New DataObject
MyDataObj.SetText ActiveCell.Text
MyDataObj.PutInClipboard
End Sub
And then pasted (manually) into NotePad. No double quotes were inserted. But I
did see a little square where the alt-enter was.
Chip has instructions that you have to follow (including the tools|references
with "Microsoft Forms 2.0 object library") on that sheet.
=========
If you wanted to copy multiple cells, this may help you:
Option Explicit
Sub testme()
Dim MyDataObj As DataObject
Dim myCell As Range
Dim myRow As Range
Dim myRng As Range
Dim myRowStr As String
Dim myStr As String
Set MyDataObj = New DataObject
Set myRng = Selection.Areas(1)
myStr = ""
For Each myRow In myRng.Rows
myRowStr = ""
For Each myCell In myRow.Cells
myRowStr = myRowStr & vbTab & myCell.Text
Next myCell
myRowStr = Mid(myRowStr, Len(vbTab) + 1) 'get rid of leading vbtab
myStr = myStr & vbCrLf & myRowStr
Next myRow
myStr = Mid(myStr, Len(vbCrLf) + 1) 'get rid of leading vbcrlf (2 chars!)
MyDataObj.SetText myStr
MyDataObj.PutInClipboard
End Sub
If you're new to macros:
Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html
David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm
(General, Regular and Standard modules all describe the same thing.)
Emil, Dilov wrote:
*When i copy text from excel cell into notepad the text is surrounded with quotes. Is it possible to format the cells in a way when i copy text from them the text not to be surrounded with quotes when pasting it in notepad? I am using excel 2007. *
Thanks!
--
Dave Peterson
