VBA code to open a Word template for edit. When clicking doc save, Word will prompt for file location and doc name, and the file location (full path with file name) will update into the hyperlink field on an Access form.
This conversation is currently closed to new comments.
Sub Command_Click() Set Word = CreateObject("word.application") Word.Visible = True Word.Documents.Open FileName:=App.Path & "\Name of Word Document File.doc" End Sub
For Saveas its replaced Word.Documents.SaveAs Filename:..... Hope this helps a bit.
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Open/save Word file to Access hyperlink