Unable to read file

  • Thread starter Thread starter sgl
  • Start date Start date
S

sgl

I have created a small application in XL with VBA.
Inadvertantly I must have changed the file extension. I
now try to open the file and get the message "Unable to
read file". Can someone help me get around this as a lot
of work has gone into this particular project.

Can i write some VBA code to get behind the scenes and
open the file.

Many thanks.
 
Does this happen on just this one file? If yes, do you have a backup?

Sometimes excel workbooks get corrupted.

One cause is opening them from a floppy and saving to that floppy. (Instead you
should use windows explorer to copy to your harddrive/LAN drive), work on it
from there, save it there and use windows explorer to copy it back to the
floppy.)

Another is opening the workbook in MSWord and saving it as an MSWord document
(with a .xls extension).

If you did the MSWord thing, you maybe able to recover a little bit of your
data by opening it in MSWord and copying and then pasting to excel. (But tons
of stuff may be lost.)

And sometimes the workbooks just get corrupted.

You might be able to recover more by using another program--both xl2002 and
OpenOffice have better reputations for opening files that earlier versions of
excel couldn't.

(http://www.openoffice.org, a 60-65 meg download or a CD)

If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com

Any chance you emailed a version to someone who could email it back?
 
This has happened on this one file on my hard disk. I
have just purchased a new computer running Windows XP. My
previous laptop was running Windows 98. No back up
available. The problem is not recovering data. This was
an application that I was developing on XL for a client
but have not completed. A lot of work has gone into it.
The data is not so important. What is important is the
application and the VBA code that I have written.

I have tried opening with MSWord but no luck. Will try
the other two cousrses mentioned.

Thanks for your advise.
-----Original Message-----
Does this happen on just this one file? If yes, do you have a backup?

Sometimes excel workbooks get corrupted.

One cause is opening them from a floppy and saving to that floppy. (Instead you
should use windows explorer to copy to your
Click to expand...
harddrive/LAN drive), work on it
 
FYI: A few people have written back saying that OpenOffice saved their VBA
project--(not to get your hopes up too high, but it could be worth the
download).
 
Back
Top