Is it Me!

[Codebug]

Trying to set the Source Document for an Excel Object on a form, does not load the document.

ie

Dim Filename AS String
Filename = "c:\myfolder\te st.xls"

CostSheet.Sourc eDoc = Filename


also how can I stop an error if the SourceDoc file or path is not valid


ps. what is Me! or Me.


often seen it in examples but cant find it in the help file or recources anywhere

[Delerna]

Me refers to the control that the code block belongs too

for example in the Form_Load event for a form called frmForm1
Me is an alias for frmForm1

so in the context of the above example

Me.Refresh
and
frmForm1.Refres h

are different ways of saying the same thing

[Delerna]

as for the other, try doing a me.refresh after you set the source file
That may fix your problem.

[Codebug]

Thanks, its clear now