Names Collection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 t

Sheet1!Z_02780717_35F7_4EAB_A61A_17F3BCED64B7_.wvu.PrintArea =Sheet1!$D$5:$F$1

Sheet1!Z_02780717_35F7_4EAB_A61A_17F3BCED64B7_.wvu.Rows =Sheet1!$11:$1

'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"

Cheer
Mark
 
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/
 
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/
Click to expand...
workbook VB project. I have noticed that the names
collection contains the following names amongst many
others.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.
Z_02780717_35F7_4EAB_A61A_17F3BCED64B7_.wvu.PrintArea
=Sheet1!$D$5:$F$18
Click to expand...
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"}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"}
 
Back
Top