Is filename stored in an Excel file?

neavt · Mar 18th, 2002, 07:57 PM

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.

Dave Hawley · Mar 18th, 2002, 08:27 PM

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).

Juan Pablo González · Mar 18th, 2002, 08:33 PM

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

neavt · Mar 18th, 2002, 08:46 PM

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.

Dave Hawley · Mar 18th, 2002, 09:00 PM

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.

anno · Mar 18th, 2002, 09:28 PM

Quote:

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?

Mar 18th, 2002, 08:33 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Or, you could open them and try to see if Excel recognizes them ! __________________ Regards, Juan Pablo González http://www.juanpg.com

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

Mar 18th, 2002, 07:57 PM	#1
neavt New Member Join Date: Mar 2002 Posts: 2	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.

Mar 18th, 2002, 08:27 PM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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).

Mar 18th, 2002, 08:46 PM	#4
neavt New Member Join Date: Mar 2002 Posts: 2	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.

Mar 18th, 2002, 09:00 PM	#5
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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.