| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Word cell containing line breaks (soft returns) to Excel | Excel Discussion (Misc queries) | |||
| Copy text from word with returns into one cell | Excel Discussion (Misc queries) | |||
| Excel returns @name? error when using a custom written function in | Excel Programming | |||
| WORD-DELIMITED string vba macro for excel/word | Excel Programming | |||
| Excel Workbook hiden when written to from Word | Excel Programming | |||
![KS[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
