Yes, you can control Word to such an extent, I have a similar system where i
record a log of all my work in a spreadsheet, which then opens a document
template and inserts items from the spreadsheet into the word document by
using a find/replace macro; i enclose the bits i want to replace in pointy
brackets like <this. as a finishing touch, it also automatically sets a
hyper-link in the spreadsheet straight to the document.

unfortunately, i don't have that spreadsheet on this laptop and the code is
too long-winded for me to start writing it from scratch now! I'm sure
someone much more professional than me will be along shortly with the
answer. but if you have any specific questions, post them and i'll try and
answer.

hth,

Tim


wrote in message
oups.com...
I am creating a dispatch system for an RV transportation company.

When an RV is dispatched to be delivered, they prepare a bill of lading
and a driver delivery agreement; the bill of lading is originally a
word document, and contains all of the legalese concerning the unit,
delivery, damages, etc. The delivery agreement basically says "this is
what we will pay for the trip". The delivery agreement is an original
excel document.

What I am writing is when the user dispatches Unit 12345 to be
delivered by driver 999, for example, it will create (from database
entries within excel), a properly formatted Bill of Lading. When Unit
12345 is scheduled for delivery and initially accepted by the company
for transport, the recipient RV dealership is already defined, and will
be defined in the database; as well as the manufacturer. The procedure
will retrieve the necessary data from the Unit and Manufacturer records
to create the B/L.

Is there a way, from within Excel, to programmatically have Excel place
these database values onto the B/L form to print the B/L form. The
original B/L was a word document, and I already have it inserted as an
object into the Excel SS. I might redesign the B/L into an Excel SS
and make it easier, but is there a way to have Excel programmatically
place the necessary values from the databases directly into the Word
object within the Excel SS?