View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
MarkC[_2_] MarkC[_2_] is offline
external usenet poster
 
Posts: 2
Default Names Collection

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

.