G
grep
I'm a complete novice to Word VBA - My only experience with it is in
Access - so this may be pretty straightforward, but nonetheless...
I've got a Word 2003 document with an embedded Excel worksheet which
calculates a value. For our purposes, we'll say that the resulting value
is in that worksheet's Sheet1.F8.
I need to set it up so that I can... I don't know... click a button, to
raise another Excel worksheet (which won't be shown in the document), to
calculate two values based on that other Excel object's Sheet1.F8 field.
Then I need those two values to be dropped into the text of the Word doc.
So:
1. How do I reference a cell in an embedded worksheet so that another
object or worksheet or something can use it?
2. How can I set up an embedded worksheet that won't get shown at all in
the printed document?
3. What field would I use to reference a cell value in an embedded
worksheet?
Thanks,
grep
Access - so this may be pretty straightforward, but nonetheless...
I've got a Word 2003 document with an embedded Excel worksheet which
calculates a value. For our purposes, we'll say that the resulting value
is in that worksheet's Sheet1.F8.
I need to set it up so that I can... I don't know... click a button, to
raise another Excel worksheet (which won't be shown in the document), to
calculate two values based on that other Excel object's Sheet1.F8 field.
Then I need those two values to be dropped into the text of the Word doc.
So:
1. How do I reference a cell in an embedded worksheet so that another
object or worksheet or something can use it?
2. How can I set up an embedded worksheet that won't get shown at all in
the printed document?
3. What field would I use to reference a cell value in an embedded
worksheet?
Thanks,
grep