Information Transfer from Excel to Word

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to transfer certain information from an Excel spreadsheet into particular sections of a Word document.

The Excel document will be completed by a 3rd party and then I would like to run a macro against it from Word just to exctract information from certain individual cells and place it in a specific location in my Word document.

I have a basic understanding of VBA and I am not sure how easy this is to complete.

Has anyone got any ideas ?

Thanks
 
If you are just transfering data from a cell(s) to predetermined
locations in a Word document, I might suggest that you Paste the
contents of the Excel cell using Paste Special, Paste Link as RTF. I do
it frequently and with the link established, the Word document will also
update as the Excel workbook is updated. No code is required to do
this. You just cant move the Word or Excel file, without reestablishing
the links.
 
Thanks Lloyd,

This is the kind of thing that I am looking for and does work in context however, this will be happening several times day in and day out.

As the data will exist in the same cells in each spreadsheet, is there any way that you can globally update all of the links (I can see that you can do it idividually) to look at a different spreadsheet ?

This would mean that I could take my Word template, save it under a new name and then update all of the links to point at the new spreadsheet.

By the way I am using Word and Excel 97.

Thanks

Tappie
 
I am not sure how you could accomplish this, short of setting up a
separate Word document for each of you worksheets, or workbooks. Each
Word doc would then update. Perhaps you could get further guidance at
one of the Word sites. One that might prove useful is
microsoft.public.word.word97vba. They might be able to suggest some
coding for Word to accomplish what you need.
 
Back
Top