Names Collection
 

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

Names Collection
 

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 .PrintArea =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

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

.