Hi.
I'm a beginner when it comes to VBA, but I know that it's possible to get Word to fetch info from a specific Excel workbook by a "If Statement".
I want to be able to use a drop down list in the word doc to choose a alternetiv, and by choosing one alternetive, the if statement goes into the excel workbook and retrieve a specific information and copies it to a textbox that already exists in the same Word doc. How should the code look?
I would be so greatful for help.
Emelie
P.S Please excuse my english, I'm Swedish D.S)
I'm a beginner when it comes to VBA, but I know that it's possible to get Word to fetch info from a specific Excel workbook by a "If Statement".
I want to be able to use a drop down list in the word doc to choose a alternetiv, and by choosing one alternetive, the if statement goes into the excel workbook and retrieve a specific information and copies it to a textbox that already exists in the same Word doc. How should the code look?
I would be so greatful for help.
Emelie
P.S Please excuse my english, I'm Swedish D.S)