Hi everyone,
It appears I am guilty of cross posting without notifying the Forum. My apology for this.
I posted the same question at "http://www.vbaexpress.com/forum/showthread.php?t=26691".
I did not mean to be rude.
Quote:
Originally Posted by salventuro
Hi Doug, Hi macropod.
Thanks for your replies. Sorry for not being a little bit clearer.
Doug, yes, each of the spreadsheets are identical in layout, all data is in Sheet1, in each Excel workbook.
What I have done is, inserted six text fields in the Word document, that are mapped to Excel.
macropod, thank you for the information. You mentioned, "LINK field pointing to any file in the source folder"
Yes, the Excel cells always in the same location in each of the workbooks. Could you please point me in the right direction for this?
Again, my sincerest thanks for your time and assistance, it is very much appreciated
|