Save a file with each worksheet?

Prosenjit Banerjee · Mar 20th, 2002, 06:22 AM

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 · Mar 20th, 2002, 06:25 AM

Hi, For question 2 just name the cells.

davegarland · Mar 20th, 2002, 06:35 AM

The microsoft site http://support.microsoft.com/default...;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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 06:22 AM	#1
Prosenjit Banerjee New Member Join Date: Mar 2002 Location: India Posts: 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?

Mar 20th, 2002, 06:25 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi, For question 2 just name the cells.

Mar 20th, 2002, 06:35 AM	#3
davegarland New Member Join Date: Mar 2002 Posts: 16	The microsoft site http://support.microsoft.com/default...;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