Posted to microsoft.public.excel.programming
|
|
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
|