Excel to run Word macro & Word returns value to be written in spreadsheet
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. |
All times are GMT +1. The time now is 03:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com