Linking a Word doc to an Excel spreadsheet - sounds easy huh!?
Posted on 2002-07-22
Thanks for reading...I'm trawling through the VB programmers guide and language reference trying to work out how I like part of a Word doc to a cell in an Excel spreadsheet;
ie I have an Excel sheet, with about 10 or so fields, say from C5 to C14, and I want each of these fields to appear in a Word Document I have. Let's say that I export various customer info from a database, convert this into Excel format, then want this to re-appear on a fax I have in Word - get the picture? :)
I'm aware of the OLE potential, and am reading the manual trying to fathom it out...but maybe you have experience in this and can assist?
If you need to know specific info, please ask...