By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,499 Members | 1,200 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,499 IT Pros & Developers. It's quick & easy.

Is it Me!

P: 25
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\test.xls"

CostSheet.SourceDoc = 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
Feb 15 '08 #1
Share this Question
Share on Google+
3 Replies


Delerna
Expert 100+
P: 1,134
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.Refresh

are different ways of saying the same thing
Feb 17 '08 #2

Delerna
Expert 100+
P: 1,134
as for the other, try doing a me.refresh after you set the source file
That may fix your problem.
Feb 17 '08 #3

P: 25
Thanks, its clear now
Feb 18 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.