Prosenjit Banerjee
New Member
- Joined
- Mar 19, 2002
- Messages
- 19
Q1. Is it possible that I save a binary file in the workbook (specially a new file for each sheet) itself programmatically? If yes then how?
Q2. I have to get an ID like thing for any cell so that I can identify it seperately even after the cell is moved anywhere. I checked whether there is a "CodeName" like property for a cell (range). But I was unable to find it out. Then, I thought that I would save (hide from the users) a unique value in the specified cells so that later after reopening the workbook I can locate the cell by retrieving the value. So, I chose the ID property of the range. But I saw that after putting a value in the ID of a cell if I save the workbook and reopen it, the ID of that particular cell becomes blank! So, can you tell me any alternative way to save a unique number for any particular cell and about what the user of Excel won't be aware of?
Q2. I have to get an ID like thing for any cell so that I can identify it seperately even after the cell is moved anywhere. I checked whether there is a "CodeName" like property for a cell (range). But I was unable to find it out. Then, I thought that I would save (hide from the users) a unique value in the specified cells so that later after reopening the workbook I can locate the cell by retrieving the value. So, I chose the ID property of the range. But I saw that after putting a value in the ID of a cell if I save the workbook and reopen it, the ID of that particular cell becomes blank! So, can you tell me any alternative way to save a unique number for any particular cell and about what the user of Excel won't be aware of?