I've been asked to find out how to do the following from one of my directors who plays alot with excel
Basically he has an excel spreadsheet with links to external MS Word Template documents. What he wants is the users to click the link, edit the template and then "save as" it into the relevant job folder (which could be anywhere on the network) He wants the filepath of this new location to be added to the adjacent cell within the orginial excel spreadsheet.
Is this at all possible? I'm not really sure where to start on this, would i require some script within the word template/document that picks up a save as routine and sends it out ?
help or pointers or any ideas would be most welcome
Thanks
Dave
Basically he has an excel spreadsheet with links to external MS Word Template documents. What he wants is the users to click the link, edit the template and then "save as" it into the relevant job folder (which could be anywhere on the network) He wants the filepath of this new location to be added to the adjacent cell within the orginial excel spreadsheet.
Is this at all possible? I'm not really sure where to start on this, would i require some script within the word template/document that picks up a save as routine and sends it out ?
help or pointers or any ideas would be most welcome
Thanks
Dave