I currently have a spreadsheet that does many calculations. I would like to set up a Word document to accept the output of these calculations. It is easy to create links to Word templates, but I want to have the links break once the template is filled out by the spreadsheet. Is this possible in code?
Currently, macros in the spreadsheet open the word templates. If it is possible to break the links in code, do I control this from the VB in excel or the VB in word?
Any ideas?
Currently, macros in the spreadsheet open the word templates. If it is possible to break the links in code, do I control this from the VB in excel or the VB in word?
Any ideas?