Extremly stupid VBA question

[Harald Krause]

Why does this not work? Dim appword As Object Public Sub start() Set appword = CreateObject("Word.Application") If appword Is Nothing Then MsgBox "appword = Nothing" Else appword.Visible = 1 End If MsgBox "Test" MsgBox "Test2" End Sub --- appword is allways nothing, CreateObject does not work... Is there any hidden security setting in Office 2000 I dont know? bb |~ bb

[MrGee]

Dim appword As Object should come after Public Sub start()

[Nick Seng]

Did you add a reference to Word10 ? Then you can just declare it like so:

Dim appWord as Word.Application

Set appWord = New Word.Application

Nick Seng (the programmer formerly known as Notorious SMC)

---

God, I pity me! - Phoncible P. Bone

[RichardGrimmer]

NOt necessarily - could be a member variable of his form, and not just a local - maybe it needs to be used by other functions / subs "Now I guess I'll sit back and watch people misinterpret what I just said......" Christian Graus At The Soapbox