LUIS FREUND
asked on
Opening a word doc from Excel and having fields populated in word from Excel when open
I have a button called "Open Word" that opens a word doc from my excel sheet.
What I'm requesting is that when you open the word doc that the RFQ number that is on cell B3 populate the Doc Ref # with that number and add -1 to it and it can be whatever number is in there. As well as the RFQ # from cell B3.
In addition I wanted the Supplier Awarded on the word doc be populated based on if you click on either cell F7, J7, or N7 to populate the Supplier Awarded on the word doc.
I used RFQ 4001 from the excel sheet and the word doc as 4001 as the example.
I--purch-Belcan-Lucho-RFQ-XXXX-CPC-.xlsm
I--purch-Belcan-Lucho-PRICE_ANALYSI.docx
What I'm requesting is that when you open the word doc that the RFQ number that is on cell B3 populate the Doc Ref # with that number and add -1 to it and it can be whatever number is in there. As well as the RFQ # from cell B3.
In addition I wanted the Supplier Awarded on the word doc be populated based on if you click on either cell F7, J7, or N7 to populate the Supplier Awarded on the word doc.
I used RFQ 4001 from the excel sheet and the word doc as 4001 as the example.
I--purch-Belcan-Lucho-RFQ-XXXX-CPC-.xlsm
I--purch-Belcan-Lucho-PRICE_ANALYSI.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER