Hi Paul

I'am still struggling with this with no success, it seems like the file name
is mandatory and can't be ignored even if we are getting the data from
current file


about the <Name element... it's not helping, it's just onother way to
replace the
<ReferenceR1C1:R7C3</Reference

with somthing like <Referencezzz</Reference

if you predefined it before like this :
<Names
<NamedRange Name="zzz" RefersTo="='Report Data'!R1C1:R7C3"/
</Names


but still the file name is required....