L
lori.c
I am working with a word 2002 document which has an embedded Exce
worksheet. The excel files perform calculations depending on what th
user fills in or selects (with radio buttons), and then completes wha
looks like a Word document.
I have 2 problems: First, I am trying to use parts of the sam
worksheet in two places in this 4-page document. Page 4 has one sectio
of the worksheet with a section that the user fills in with a numbe
ranking, 1-5, and then Cell L39 sums those rankings. The total in L3
then shows up in another area of the same worksheet, and also on page
of the Word document. When I try to copy the worksheet to use th
calculation part on page 4 of the Word document, cell L39 isn’
“linked” to the same cell L39 on page 1.
Also, this Word document will be posted on a website, and I need t
make sure that the Excel file stays with the Word file. Otherwise, whe
someone tries to use the calculation portion of the Word document, th
Excel file won’t be available (I think).
I can't attach the file, since it is a .doc file.
Any help would be appreciated. Also, I don't know how to use VBA, s
please keep it simple, if possible
worksheet. The excel files perform calculations depending on what th
user fills in or selects (with radio buttons), and then completes wha
looks like a Word document.
I have 2 problems: First, I am trying to use parts of the sam
worksheet in two places in this 4-page document. Page 4 has one sectio
of the worksheet with a section that the user fills in with a numbe
ranking, 1-5, and then Cell L39 sums those rankings. The total in L3
then shows up in another area of the same worksheet, and also on page
of the Word document. When I try to copy the worksheet to use th
calculation part on page 4 of the Word document, cell L39 isn’
“linked” to the same cell L39 on page 1.
Also, this Word document will be posted on a website, and I need t
make sure that the Excel file stays with the Word file. Otherwise, whe
someone tries to use the calculation portion of the Word document, th
Excel file won’t be available (I think).
I can't attach the file, since it is a .doc file.
Any help would be appreciated. Also, I don't know how to use VBA, s
please keep it simple, if possible