Hi all,
I currently have the following code that copies a range of cells from Excel and pastes into a new blank word document.
I then need the contents of the word document to be copied, but all the methods that I've found via googling (Selection.Wholestory etc..) don't seem to work.
How can I make it select and then copy the contents of the word doc?
Please Login or Register to view this content.
I dont know much about cross-application programming, but i can help you shorten your code.
In place of the above code, try this -
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Selecting for what purpose ?(avoid select/activate in VBA !)
Please Login or Register to view this content.
End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks