Is filename stored in an Excel file?
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Is filename stored in an Excel file?

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

    Default

     
    Big problem. Backup software did not backup long filename in Windows 95. Backup software truncated to 8 positions and I need to know if a VB program or another method can be used to retrieve the original filename from the file.

  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 neavt

    If it's "Backup software" surely it created a copy and not saved over the top of the original???

    Anyway have a look in your temp folder, or old emails (as attachment).



  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or, you could open them and try to see if Excel recognizes them !
    Regards,

    Juan Pablo González
    http://www.juanpg.com

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

    Default

    Actually, the hard disk took a crash and it's since been replaced. I no longer have the original file, only the backup copy which is 8 characters. My IT dept is not any help, so I'm searching web sites to see if this can be done. I had several of these files and they were linked together. The last resort is to open each file and manually re-link them. Thanks for any help.

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

    Default

    Hi neavt

    Typical IT department! I find it hard to believe that a 'real IT person' could not get this for you.

    Anyway, you can easily replace links in a Workbook with Edit>Links>Change Source.



  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    I had several of these files and they were linked together.
    hi neavt
    long shot - if the spreadsheet was linked to other files, and if i have this right and you are just looking for the old filename, if you haven't updated links since you lost the file, could you open one of the linked files (ignoring the update links prompt) and look at edit>links to see if it shows the workbook's original name?

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