Microsoft Excel Error

[ForSale]

I've been working on this file all day, then i closed it, went to lunc
and when i came back i opened it again. now, every time i open it
get the microsoft error - the one that asks to send the report or don'
send it.
WHAT THE WORLD! when i hit don't send, it tries to recover th
workbook, but none of the macros are there.
any thoughts

 

[Stan Scott]

Either open the workbook while holding the SHIFT key down, to stop macros
from processing, or set your security settings so that you're prompted to
run the macros. That way, you can open it without running the macros, and
you can take a good look at your open routines.

Stan Scott
New York City

 

[ForSale]

Thanks Stan
i opted to disable the macros from running, and it still happened a
soon as it opened. i have tried this on another machine with the sam
response

 

[keepITcool]

also try:
in vbe immediate:
application.enableevent=false
(to disable eventhandlers from compiling (and crashing)

then open your workbook.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ForSale wrote :

 

[ForSale]

Thanks, however, it still crashed when i opened it with the event
enabled.
The one thing that i noticed this time was that on the top bar it sai
'Microsoft Excel - Skill Grid [Group]'
it's never had the [Group] part before. and it seems like it opene
two of the same file, not sure. down on the task bar there are tw
Excels with the same name. maybe one of those is the error.
weird that this worked before i ate at Subway...
any other ideas? it'

 

[keepITcool]

can you mail the offender?..zip it first please?

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ForSale wrote :

 

[ForSale]

I wish i could, however, it is full of confidential work-relate
information. if i could only open it and delete the sensitive info,
could.
thanks though

 

[keepITcool]

well re confidentiality.. it's truely confidential now
your company wont be able to read it either


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ForSale wrote :

 

[keepITcool]

see for some more suggestions
http://www.jkp-ads.com/CorruptFiles.htm



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ForSale wrote :

 

[ForSale]

Thanks for all the suggestions cool,
unfortunately even after trying all of them on that site, i still can'
access this file. i've tried it on other machines and verified tha
it's not excel all to gether, it's just this one file.
i'm about to leave work for the weekend. maybe everyone can put thei
brains together over the weekend and when i come back in monday it'l
be okay!
i really hate to lose everything on here. i've put a lot of work int
it. if i could just get the macros off of it, i would be happy. i ca
re-do the sheets and formatting and everything, but the macros....
thanks.
have a great weeken

 

[ForSale]

Okay, i'm back from the weekend. still having problems opening to dan
thing.
i did make another discovery that may help you - when it opened,
selected sheet1 and selected all. then i created a new workbook an
hit paste. as soon as i pasted it crashed. perhaps there is somethin
corrupt on this page???
thanks for any hel

 

[keepITcool]

I thought you wanted to save your CODE and that DATA was secondary.
...

FIRST make a copy of the file in explorer

apparently you CAN open the thing..
first try to SAVE your code..by exporting the modules and forms
then delete the modules

saveas/close/reopen

then try to clear the sheets
(not delete m yet)
saveas/close/reopen.

it's cumbersome but maybe you can find where the culprit is.
cant help you any further.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


ForSale wrote :

 

[ForSale]

The code is my main concern still.
I am able to open the file, however as soon as it opens completely, i
gives the error. it won't let me do anything until i either choos
'send report' or 'don't send report'. once i choose either one, i
closes the file, tries to repair it, then reopens it without th
macros/codes/modules. is there anyway to export the modules withou
opening the file

 

[ForSale]

Okay, i have determined that he corruptness of this file is in the shee
entitled "all". this is the only sheet visible when it is open, so
can't use the Hold cntl + pgdwn as there are no more sheets visible.
have tried a lot of different things to try to open this file on
different sheet than the one that it is saved on, including:

Private Sub CommandButton1_Click()
Application.ScreenUpdating = False
Workbooks.Open Filename:= _
"w:\\skill grid.xls"

Windows("skill grid.xls").Activate
Sheets("all").Select
Application.CutCopyMode = False
Sheets("BGS").Visible = True
Sheets("BGS").Select
Windows("book2.xls").Activate
Sheets("Sheet1").Select


End Sub

any other suggestions, now that i know more of where the corruptnes
lays? i still have basically the same question, can i save the macro
at least

 

[ForSale]

okay, i hate to bring up an old post that has already been kicking dea
horses in the mouths; i am still needing to get the macros off of thi
file, and can't open it at all! it is apparent that no one can provid
advice over this forum to open it. i checked with my supervisor and sh
is willing to let me e-mail it to someone who think that they may b
able to uncorrupt it.
if anyone thinks they can uncorrupt this file, please give me you
e-mail address and i will send it over.
thanks