VBA - Use embeded excel in word to calculate and insert into a userform text box in word
Posted on 2015-01-14
I'm trying to figure out a way to do calculations in a word userform, its a very complex calculation so it would be best if it was possible to embed a excel document in the word document, do the calculation and then send back the values into the textboxes from the cells... is this possible and how? or is there a better way to do this?
please advise, thanks alot in advance!