View Full Version : Why does this code work as a sub on a label but won't work as a module


Mike375
07-30-2008, 08:34 AM
As a module with Public Function called in either a macro or another block of code the highlighted line comes up bit it works perfectly from behind a label.

Object required and Error 424

Dim Word_Obj As Object
Forms![Form1]!MyOle.Verb = -2
Forms![Form1]!MyOle.Action = 7
Set Word_Obj = MyOle.Object.Application.WordBasic
Word_Obj.ViewNormal

Word_Obj.FileSaveAs ("c:\Letters\BD.doc")
Call QW

khawar
07-30-2008, 10:14 AM
Set Word_Obj = MyOle.Object.Application.WordBasic

Replace it with

Set Word_Obj = Forms![Form1]!MyOle.Object.Application.WordBasic

khawar
07-30-2008, 10:14 AM
Set Word_Obj = MyOle.Object.Application.WordBasic

Replace it with

Set Word_Obj = Forms![Form1]!MyOle.Object.Application.WordBasic

Mike375
07-30-2008, 10:26 AM
Many thanks. Worked like a charm.