I am trying to open, edit, and save a word document (by calling a module) if a user response is "Yes" using excel 2010 VBA. If the user answers yes then a word document is opened from a location, the user edits it, and then saves the changes to a new location. If it is "No" the VBA moves on to the next line. I don't know if the below is the best way or if it is close, but hopefully it is a start. Thank you .

VB
Please Login or Register  to view this content.
NewWord Module
Please Login or Register  to view this content.