is there any way to copy data from and excel cell to a word template?
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!
is there any way to copy data from and excel cell to a word template?
Re: Copy Data
Hi,
Yes there is, one application needs to do the driving (can be either I would guess). It sets up variables to containg the other Application and then Document or Workbook. You then get the data from the cells individually and place them in the document. The trick bit is the pasting into Word as you have to give some idea of the location you want to paste into. Use bookmarks for this.
There are a number of posts here on this subject, try a few searches.
John
Don’t have an account yet? Register yourself now and be a part of our community!