Dave,
Thanks for the information. I have downloaded the Report
Manager addin for Excel 2002 from the microsoft website
which appears to recognise the names created.
Cheers
MarkC
-----Original Message-----
In an earlier discussion, Jan Karel Pieterse wrote that
wrn.newreport gets
created when using the report manager.
I don't recall ever using the report manager, but I've
seen names that start
with wrn., too.
I figure that excel needs them. I shouldn't care about
them (for the most
part!).
And this may make your name processing easier to check:
Jan Karel Pieterse's (with Charles Williams and Matthew
Henson) Name Manager.
You can find it at:
NameManager.Zip from http://www.bmsltd.ie/mvp/
MarkC wrote:
I am working with the names collection witihin an Excel
workbook
VB project. I have noticed that the names
collection contains the following names amongst many
others.
I know the first two names relate to Custom Views and
were generated by Excel but I do not know what the second
two names refer to. I am guessing these these were also
generated by Excel.
Does anyone know what the second two names refer to
Sheet1!
Z_02780717_35F7_4EAB_A61A_17F3BCED64B7_.wvu.PrintA rea
=Sheet1!$D$5:$F$18
Sheet1!Z_02780717_35F7_4EAB_A61A_17F3BCED64B7_.wvu .Rows
=Sheet1!$11:$14
'I&I data'!wrn.BW._.print. ={"Black & White
print",#N/A,FALSE,"Cust4";"Black & White
print",#N/A,FALSE,"Cust5";"Black & White
print",#N/A,FALSE,"Cust6";"Black & White
print",#N/A,FALSE,"Cust7";"Black & White
print",#N/A,FALSE,"Cust8";"Black & White
print",#N/A,FALSE,"Cust9"}
'IT&Ops data'!wrn.BW._.print. ={"Black & White
print",#N/A,FALSE,"Cust4";"Black & White
print",#N/A,FALSE,"Cust5";"Black & White
print",#N/A,FALSE,"Cust6";"Black & White
print",#N/A,FALSE,"Cust7";"Black & White
print",#N/A,FALSE,"Cust8";"Black & White
print",#N/A,FALSE,"Cust9"}
Cheers
Mark
--
Dave Peterson
.