![]() |
#1
|
|||
|
|||
![]()
I try start up word from Access by VBA and use this code:
Code:
Dim objWord As Word.Application Dim bigDoc As Word.Document Dim WordHeaderFooter As HeaderFooter If IsAppRunning("Word.Application") Then Set objWord = GetObject("Word.Application") Else Set objWord = CreateObject("Word.Application") Set bigDoc = objWord.Documents.add objWord.Visible = True With bigDoc .Sections(1).Headers(wdHeaderFooterPrimary).Range.Text = "Alle registrerede data vedr. PersonId: " & _ Me.PersonID & " " & HentFMENavn(Me.PersonID) .Sections(1).Footers(wdHeaderFooterPrimary).Range.Text = "Dokumentet er sammensat pr. " & _ StrConv(Format(Date, "dddd"), vbProperCase) & " den " & Date End With When word is running (not document open) is gives me bad syntaks: ???????? Where is my screendump, it was here when I wrote the message ?????? What is wrong here ? EDIT: It seems like ONLY this is needed: Set objWord = GetObject(, "Word.Application") Last edited by ksor; 02-01-2018 at 11:36 AM. |
#2
|
||||
|
||||
![]()
Ordinarily, with early binding, you'd use something like:
Code:
Dim wdApp As Word.Application, bStrt As Boolean On Error Resume Next bStrt = False ' Flag to record if we start Word, so we can close it later. Set wdApp = GetObject(, "Word.Application") 'Start Word if it isn't running If wdApp Is Nothing Then Set wdApp = CreateObject("Word.Application") If wdApp Is Nothing Then MsgBox "Can't start Word.", vbExclamation Exit Sub End If ' Record that we've started Word, so we can terminate it later. bStrt = True End If On Error GoTo 0 wdApp.Visible = True Dim wdApp As Word.Application with: Dim wdApp As Object
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Error message when starting Outlook 2007 | WalterW | Outlook | 10 | 07-26-2015 11:16 AM |
Error when starting Word & Excel | mango | Word | 0 | 08-15-2013 07:53 AM |
Help with error upon starting Outlook | chrisj | Outlook | 1 | 02-21-2012 08:55 PM |
Help finding starting point on project (Excel/Access?) | ndk415 | Office | 1 | 06-19-2011 03:28 AM |
Error Starting MS Help | Renee Hendershott | Office | 0 | 01-22-2006 03:40 PM |