close

I have the following probelm.
I have a workbook with a number of modules(vba code).
I save it to 2 different partitions (just in case).
It happens regularly that I get an error message that option is not
available and then the sheet opens, formatting has dissapeard and all
the modules are gone.
I do not get a virus message or anything else when saving, and my
protection is set low so I don't get the prompt if I want the macro's
to run.
It happens more often on one of the HDD partitions than the other.

Any Ideas? Suggestions? Coukd it be a Bad Disk (spank it!) or something
known?

Thanks, Hans (hhalle)--
hhalle

Male
------------------------------------------------------------------------
hhalle's Profile: www.excelforum.com/member.php...oamp;userid=20829
View this thread: www.excelforum.com/showthread...hreadid=507120It sounds to me like the workbook is corrupted.

Lots of people have praised OpenOffice.org for saving their data and code.

www.openoffice.org, a 60-65 meg download or a CD

There are commercial recovery services. I've never used it, but you might want
to check into:
www.officerecovery.com

And sometimes newer versions of excel can open files that older versions can't.
(And sometimes just different versions may work, too!)

hhalle wrote:
gt;
gt; I have the following probelm.
gt; I have a workbook with a number of modules(vba code).
gt; I save it to 2 different partitions (just in case).
gt; It happens regularly that I get an error message that option is not
gt; available and then the sheet opens, formatting has dissapeard and all
gt; the modules are gone.
gt; I do not get a virus message or anything else when saving, and my
gt; protection is set low so I don't get the prompt if I want the macro's
gt; to run.
gt; It happens more often on one of the HDD partitions than the other.
gt;
gt; Any Ideas? Suggestions? Coukd it be a Bad Disk (spank it!) or something
gt; known?
gt;
gt; Thanks, Hans (hhalle)
gt;
gt;
gt; --
gt; hhalle
gt;
gt; Male
gt; ------------------------------------------------------------------------
gt; hhalle's Profile: www.excelforum.com/member.php...oamp;userid=20829
gt; View this thread: www.excelforum.com/showthread...hreadid=507120

--

Dave Peterson

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()