Problems with SourceDoc Property

[adfsmf]

I get the following error when I try to set the SourceDoc property on an OLE object in one of my MS Access forms:

Run-time Error 2101: "The setting you entered isn't valid for this property."

My path an file and filename are:

OLE.SourceDoc = "H:\TestOLEAuto.xls!R1C1:R30C15"

I checked the help file but it wasn't any help. Is there something I need to do before setting this property? HELP!!!

 

[kjv1611]

What does your code look like that is calling that reference?

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV

 

[adfsmf]

With Me![OLEExcelSheet]
.Enabled = True
.Locked = False
.OLETypeAllowed = acOLELinked
.Class = "Excel.Sheet"
.SourceDoc = "G:\TestOLEAuto.xls"
.SourceItem = "R1C1:R7C4"
.Action = acOLECreateLink
.SizeMode = acOLESizeZoom
End With

 

[kjv1611]

You might want to take a look at this link:

http://www.kbalertz.com/kb_827983.aspx

I personally do not see anything that could be wrong, unless you have to use brackets or parenthesis, but I've never seen a property that I can recall that has to be set that way.. This article says something about that error, don't know if it will help or not..

Stephen
"Jesus saith unto him, I am the way, the truth, and the life:
no man cometh unto the Father, but by me." John 14:6 KJV