I have macro to copy the data from excel file and to paste it in a word file by opening word file and save it in the same folder where the excel is. The data pasted in word file is not formatted correctly. I want to paste the excel sheet data as picture using paste special in word file. The code to use for this should be in macros code in excel file. The code written for opening the word file and saving it after pasting excel data is as under. Will anybody give solution?
ThanksPlease Login or Register to view this content.
Bookmarks