PerksP
asked on
Opening a Word Document from MS Access 2010
I hope someone can help.
I have been using the following code successfully in a database that was written in Access 2003. When I try to use it in an Access 2010 database I get a Run time Error 424 Object Required on line Set WordDoc. I have checked references and Access 14.0 Object Library, Word Object Library 14.0 are both set. Is there a different coding needed for 2010?
'Open Word Document for Merge
Dim WordApp, WordDoc As Object
Set WordApp = CreateObject("Word.Applica tion")
Set WordDoc = WordApp.Documents.Open(For ms!HomePag e_TaskList !Documents Folders & Me.Letters.Column(2))
WordApp.Visible = True
I have been using the following code successfully in a database that was written in Access 2003. When I try to use it in an Access 2010 database I get a Run time Error 424 Object Required on line Set WordDoc. I have checked references and Access 14.0 Object Library, Word Object Library 14.0 are both set. Is there a different coding needed for 2010?
'Open Word Document for Merge
Dim WordApp, WordDoc As Object
Set WordApp = CreateObject("Word.Applica
Set WordDoc = WordApp.Documents.Open(For
WordApp.Visible = True
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER