Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
Coming from excel copy range into pasting unformatted text into Word and also
into Notepad. Thanks Dan |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
Please don't keep starting new threads with the same question!
Somebody obviously DOES REALLY KNOW, because at least one person (me) has posted a solution that works (hard to tell if there have been more, since you're starting new threads). If it's not working for you, please include more information - i.e., what is NOT working for you. What happens when you follow the steps I gave you? Just posting "it doesn't work" is utterly unhelpful. In article , Daniel wrote: Coming from excel copy range into pasting unformatted text into Word and also into Notepad. Thanks Dan |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
JE,
You never answered the question, where is the VB code you are suggesting? By stating that is a two step process does not say anything Thx Dan Daniel "JE McGimpsey" wrote: Please don't keep starting new threads with the same question! Somebody obviously DOES REALLY KNOW, because at least one person (me) has posted a solution that works (hard to tell if there have been more, since you're starting new threads). If it's not working for you, please include more information - i.e., what is NOT working for you. What happens when you follow the steps I gave you? Just posting "it doesn't work" is utterly unhelpful. In article , Daniel wrote: Coming from excel copy range into pasting unformatted text into Word and also into Notepad. Thanks Dan |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
One way:
Selection.PasteSpecial _ Link:=False, _ Placement:=wdInLine, _ DisplayAsIcon:=False, _ DataType:=wdPasteText In article , Daniel wrote: You never answered the question, where is the VB code you are suggesting? By stating that is a two step process does not say anything |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
What JE suggested in one of your other posts was to create a shortcut
in Word to do the paste. You select what you want in Excel, go to Word, and click the button to paste it as unformatted. Instructions for setting this up can be found at the link below. http://pubs.logicalexpressions.com/p...cle.asp?ID=128 Daniel wrote: JE, You never answered the question, where is the VB code you are suggesting? By stating that is a two step process does not say anything Thx Dan Daniel "JE McGimpsey" wrote: Please don't keep starting new threads with the same question! Somebody obviously DOES REALLY KNOW, because at least one person (me) has posted a solution that works (hard to tell if there have been more, since you're starting new threads). If it's not working for you, please include more information - i.e., what is NOT working for you. What happens when you follow the steps I gave you? Just posting "it doesn't work" is utterly unhelpful. In article , Daniel wrote: Coming from excel copy range into pasting unformatted text into Word and also into Notepad. Thanks Dan |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
Thank you John
"JW" wrote: What JE suggested in one of your other posts was to create a shortcut in Word to do the paste. You select what you want in Excel, go to Word, and click the button to paste it as unformatted. Instructions for setting this up can be found at the link below. http://pubs.logicalexpressions.com/p...cle.asp?ID=128 Daniel wrote: JE, You never answered the question, where is the VB code you are suggesting? By stating that is a two step process does not say anything Thx Dan Daniel "JE McGimpsey" wrote: Please don't keep starting new threads with the same question! Somebody obviously DOES REALLY KNOW, because at least one person (me) has posted a solution that works (hard to tell if there have been more, since you're starting new threads). If it's not working for you, please include more information - i.e., what is NOT working for you. What happens when you follow the steps I gave you? Just posting "it doesn't work" is utterly unhelpful. In article , Daniel wrote: Coming from excel copy range into pasting unformatted text into Word and also into Notepad. Thanks Dan |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
STILL NO ANSWER, DOES ANYBODY REALLY KNOWS
JW's second code in your original thread seems to work fine. When copying a
range you are going to get tabs between cells and new lines for each row. In case you can't find it, Here is JW's code This "should" work, but for some reason it is still copying the table structure. I'll keep fooling around with it. Sub toWord() Dim objWord As Object Set objWord = CreateObject("Word.Application") objWord.Visible = True Sheets("Sheet1").Range("A1:C4").Copy objWord.Documents.Add objWord.Selection.PasteSpecial Link:=False, _ DataType:=wdPasteText, Placement:=wdInLine, _ DisplayAsIcon:=False Application.CutCopyMode = False Set objWord = Nothing End Sub Peter Richardson PS: Yelling for a reposnce and starting 2 additional threads on the topic in under 2 hours seems a might rude to me. It is amazing the number of sub hour responces on here but you really shouldn't expect it "Daniel" wrote: Thank you John "JW" wrote: What JE suggested in one of your other posts was to create a shortcut in Word to do the paste. You select what you want in Excel, go to Word, and click the button to paste it as unformatted. Instructions for setting this up can be found at the link below. http://pubs.logicalexpressions.com/p...cle.asp?ID=128 Daniel wrote: JE, You never answered the question, where is the VB code you are suggesting? By stating that is a two step process does not say anything Thx Dan Daniel "JE McGimpsey" wrote: Please don't keep starting new threads with the same question! Somebody obviously DOES REALLY KNOW, because at least one person (me) has posted a solution that works (hard to tell if there have been more, since you're starting new threads). If it's not working for you, please include more information - i.e., what is NOT working for you. What happens when you follow the steps I gave you? Just posting "it doesn't work" is utterly unhelpful. In article , Daniel wrote: Coming from excel copy range into pasting unformatted text into Word and also into Notepad. Thanks Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help with IF, if it is the answer.. | Excel Discussion (Misc queries) | |||
Calculator Answer Doesn't Match Excel Answer | Excel Discussion (Misc queries) | |||
plz answer | Excel Discussion (Misc queries) | |||
=D6-E6. Answer in F6. I want answer in F6 only if value in E6? | Charts and Charting in Excel | |||
i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) |