Save a file with each worksheet?
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Save a file with each worksheet?

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    India
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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?

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi, For question 2 just name the cells.



  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com