|
code
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Excel automationHello,
I am searching for Excel property similar to .Tag property to store additional data in the Excel Spreadsheet not visible to the user. That data will be different for each spreadsheet row. How to do that? Jack "Jack" <replyto@it> wrote in message What about adding a Comment? Not completely invisible to the user I know.news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... > Hello, > I am searching for Excel property similar to .Tag property to > store additional data in the Excel Spreadsheet not visible to the user. > That data will be different for each spreadsheet row. > How to do that? Show quoteHide quote > Jack > I tried that.
There is a small icon indicator when comment is set. How to read back that comment ? Thanks, Jack Show quoteHide quote "Michael C" <nospam@nospam.com> wrote in message news:ObMi4gWWHHA.1200@TK2MSFTNGP02.phx.gbl... > "Jack" <replyto@it> wrote in message > news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... >> Hello, >> I am searching for Excel property similar to .Tag property to >> store additional data in the Excel Spreadsheet not visible to the user. >> That data will be different for each spreadsheet row. >> How to do that? > > What about adding a Comment? Not completely invisible to the user I know. > > >> Jack >> > > "Jack" <replyto@it> wrote in message If Not Range.Comment Is Nothing thennews:ePheftWWHHA.1208@TK2MSFTNGP03.phx.gbl... >I tried that. > There is a small icon indicator when comment is set. > How to read back that comment ? Range.Comment.Something I think. Michael Jack,
A Range has an ID property, that can be similar to a .Tag. Only Read/write through code. However, it is not stored with the WB. NickHK Show quoteHide quote "Jack" <replyto@it> wrote in message news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... > Hello, > I am searching for Excel property similar to .Tag property to > store additional data in the Excel Spreadsheet not visible to the user. > That data will be different for each spreadsheet row. > How to do that? > Jack > > How about using a hidden column??? That has worked for me in the past.
Show quoteHide quote "NickHK" <TungChe***@Invalid.com> wrote in message news:eoMY7jYWHHA.4384@TK2MSFTNGP02.phx.gbl... > Jack, > A Range has an ID property, that can be similar to a .Tag. Only Read/write > through code. > However, it is not stored with the WB. > > NickHK > > "Jack" <replyto@it> wrote in message > news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... >> Hello, >> I am searching for Excel property similar to .Tag property to >> store additional data in the Excel Spreadsheet not visible to the user. >> That data will be different for each spreadsheet row. >> How to do that? >> Jack >> >> > > If the hidden column is used how that relates to the columns numbering?
Where can I read more about it? Jack Show quoteHide quote "Brian" <bkstig***@usa.net> wrote in message news:%23QLbJWdWHHA.5060@TK2MSFTNGP06.phx.gbl... > How about using a hidden column??? That has worked for me in the past. > > > > "NickHK" <TungChe***@Invalid.com> wrote in message > news:eoMY7jYWHHA.4384@TK2MSFTNGP02.phx.gbl... >> Jack, >> A Range has an ID property, that can be similar to a .Tag. Only >> Read/write >> through code. >> However, it is not stored with the WB. >> >> NickHK >> >> "Jack" <replyto@it> wrote in message >> news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... >>> Hello, >>> I am searching for Excel property similar to .Tag property to >>> store additional data in the Excel Spreadsheet not visible to the user. >>> That data will be different for each spreadsheet row. >>> How to do that? >>> Jack >>> >>> >> >> > > Pity.
I need to store that value. Jack Show quoteHide quote "NickHK" <TungChe***@Invalid.com> wrote in message news:eoMY7jYWHHA.4384@TK2MSFTNGP02.phx.gbl... > Jack, > A Range has an ID property, that can be similar to a .Tag. Only Read/write > through code. > However, it is not stored with the WB. > > NickHK > > "Jack" <replyto@it> wrote in message > news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... >> Hello, >> I am searching for Excel property similar to .Tag property to >> store additional data in the Excel Spreadsheet not visible to the user. >> That data will be different for each spreadsheet row. >> How to do that? >> Jack >> >> > > The hidden column is accessed just like a visible column. No difference.
Show quoteHide quote "Jack" <replyto@it> wrote in message news:OHdUV2hWHHA.3652@TK2MSFTNGP04.phx.gbl... > Pity. > I need to store that value. > Jack > > "NickHK" <TungChe***@Invalid.com> wrote in message > news:eoMY7jYWHHA.4384@TK2MSFTNGP02.phx.gbl... >> Jack, >> A Range has an ID property, that can be similar to a .Tag. Only >> Read/write >> through code. >> However, it is not stored with the WB. >> >> NickHK >> >> "Jack" <replyto@it> wrote in message >> news:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... >>> Hello, >>> I am searching for Excel property similar to .Tag property to >>> store additional data in the Excel Spreadsheet not visible to the user. >>> That data will be different for each spreadsheet row. >>> How to do that? >>> Jack >>> >>> >> >> > > "Jack" <replyto@it> wrote in message You have been given ideas already such as comments, cell tags (don't persistnews:elEuQWVWHHA.2256@TK2MSFTNGP02.phx.gbl... > Hello, > I am searching for Excel property similar to .Tag property to > store additional data in the Excel Spreadsheet not visible to the user. > That data will be different for each spreadsheet row. > How to do that? > Jack > with save close), hidden column. Also columns per sheet on an xlVeryHidden sheet, hidden Names for cells in a column, either as named cells "Row00123" & "_myData" or named data "Row00123" refersto "my data", hidden textboxes (named "Row00123" to move with cells) and no doubt more. Each method will have advantages & disadvantages depending on your overall scenario. With any method you'll need consider how to cater for user moving/deleting cells in 'the' column, or entire rows, or deleting 'the' column, which would delete some but not all of the various methods. The methods that are not deleted could loose their original relationship with the row id. It might be worth asking in .excel.programming but explain why you want to store the data and how, if at all (eg protected) user might move or delete cells/rows/columns. Regards, Peter T 
Other interesting topics
Sad
Inline Assembly In VB6 Database connection problem on VB6.0 How to open a CMD Line exe as hidden and wat for it to finish Have a problem that is stumping me. MS Winsock Control ports don't free up VB6 DLL Assembly Compile Link how??? Problem populating a combobox if cases differ Full Control to Users programmatically Help in translating C to VB |
|||||||||||||||||||||||
