>I prepare a table in Excel within a Using () statement. At the end I UsedRange.Copy() to what I understand is the clipboard. Then I Selection.PasteExcelTable in a Word document.
>I get an COM Exception "command failed".
>When I activate the word document and press Ctrl+V the table gets copied.
>I wonder if that has something to do with the fact that maybe I must reactivate the Word document in code.
>The word document gets created also within a Using() statement. I execute the Excel procedure from within the Using(Word) statement.
>
>I tried the Activate method of the Word.Application object and also when I wait for 5 seconds after the Activate().
Actual code might be useful......
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only