General discussion

Locked

Open/save Word file to Access hyperlink

By qtgirl88 ·
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.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Open/save Word file to Access hyperlink

by carquiza In reply to Open/save Word file to Ac ...

Hi,

Why not try this code?

Insert this code on a button or hyperlink:

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.

Cheers,

Mel Arquiza
Home Page Design
http://hpd.welcome.to

Collapse -

Open/save Word file to Access hyperlink

by qtgirl88 In reply to Open/save Word file to Ac ...

The question was auto-closed by TechRepublic

Collapse -

Open/save Word file to Access hyperlink

by maxwell edison In reply to Open/save Word file to Ac ...

See thos site, "FREE Word add-in utilities"

http://www.cdev.co.uk/utils.htm

(REMOVE SPACES from the pasted URL.)

Examples and downloads.

Maxwell

Collapse -

Open/save Word file to Access hyperlink

by qtgirl88 In reply to Open/save Word file to Ac ...

The question was auto-closed by TechRepublic

Collapse -

Open/save Word file to Access hyperlink

by qtgirl88 In reply to Open/save Word file to Ac ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums