Using Excel & Word 2003.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tripscott@gmail.com - 30 Nov 2006 13:18 GMT

I am cross posting this because I haven't gotten an answer in the excel
programming group.

Using Excel & Word 2003.

I have a spreadsheet that contains a lists of part numbers. Each part
number has a corresponding Word document. Currently I have Excel open
that document in Word. A Word macro checks the value in a table's cell
and if the cell is blank, enters "A" and then saves the document. What
I need to program in now is if this happens to write the part number in
a different spreadsheet (same workbook) in Excel. I can't seem to
figure out how to send a variable from Word to Excel.

Can anyone help me out? Thanks a bunch.

Reply to this Message

Jay Freedman - 30 Nov 2006 14:34 GMT

Since both Word and Excel use VBA, you can have one macro do all this work.
I'd suggest that the macro should run in Excel, not in Word -- but it can
still open Word documents and manipulate their contents. That same macro can
then write to another spreadsheet of the workbook. An example of an Excel
macro that does things in Word is at
http://www.word.mvps.org/FAQs/InterDev/ControlWordFromXL.htm.

If you need more help with this, post the code of the existing Word macro.

Signature

Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> I am cross posting this because I haven't gotten an answer in the
> excel programming group.
[quoted text clipped - 10 lines]
>
> Can anyone help me out? Thanks a bunch.

Reply to this Message

Rate this thread: