Thread: [Solved] Opening a document with VBA
View Single Post
 
Old 09-25-2014, 11:26 AM
jamtay317 jamtay317 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Sep 2014
Posts: 1
jamtay317 is on a distinguished road
Default Opening a document with VBA

Hello I am new to this site, and thank you for taking the time to read this! I am working on an Access database, when I Push a button the goal is for for it to open a document that I have already set up with Mail Merge. When I push the button it opens the document, but I cannot scroll between the different records.

Here is the code that I've already created.
Code:
    Private Sub cbFESOP_Click()
    Dim wrd As Word.Application
    Set wrd = CreateObject("Word.Application")
    Dim doc As Word.Document
    Set doc = wrd.Documents.Open("Y:\Reports\FESOP Certification.docx")
    
    wrd.Visible = True
End Sub

any and all help will be appreciated thank you!
Reply With Quote