Save a file with each worksheet?

[Prosenjit Banerjee]

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?

 

[Dave Hawley]

Hi, For question 2 just name the cells.

 

[davegarland]

The microsoft site http://support.microsoft.com/default.aspx?scid=kb;en-us;Q157568
states that you can do this with code like this

Sub SaveSingleSheet()

Worksheets("sheet2").SaveAs filename:="test.xls", _
FileFormat:=xlExcel4

End Sub

but when I try this with XL97 it gives me an illegal operation message so no good!!
Maybe it will work on your system