Yeah, sorry Dave, I meant I did find the xlb's, changed them, and still Excel
crashed so renaming didn't work. I will try the new workbook idea and let you
know how that goes. Thanks again for all the help!

"Dave Peterson" wrote:

First, what does "no avail" mean? Does that mean you found it, renamed it and
tested it and that failed--or does that mean you still couldn't find it?

If you couldn't find it, you may not have a *.xlb file. It only gets created
when you need it (like when you customize a toolbar).

If you want to verify that your find works, make a minor modification to a
toolbar in excel. Then close excel and try to find *.xlb. You should be able
to find it. If you can't, then you should try the CMD stuff once more.

But...

I don't see anything in that portion of your code that even runs when excel is
closing. If you copy and paste it into a new workbook's module, then save and
close that new workbook, does excel still crash?

I have no list of everything excel does when it closes.

Matt wrote:

Thanks Dave! I have tried the xlb method but to no avail. Can you tell me
where I can see everything that occurs when closing Excel? I am referring to
all processes that occur on the system when just closing so I can look at it
in comparison to everything. It is weird. That section of code is the only
part that makes the crash occur. We are so stumped! Thanks again though!

"Dave Peterson" wrote:

I don't see anything in the posted code that would even run when excel (or the
workbook) closes. And I don't see anything that would make excel crash even if
all that code ran.

I'm still guessing the *.xlb file.

Matt wrote:

Here ya go!

Sub gen1()

'



Sheets("staging").Select

Range("I2").Select

ActiveCell.FormulaR1C1 = "1"

Range("A1").Select

Call copy

Sheets("1").Select

Range("A1").Select

Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _

SkipBlanks:=False, Transpose:=False

Range("A1").Select

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _

:=False, Transpose:=False

Range("A1").Select

ActiveWindow.SmallScroll Down:=0

Call fix_x

Sheets("1").Select

Call hide

Range("C2").Select

UserForm1.hide

End Sub





Sub hide()

'

' This hides the cost section, as we have not received costs

'

Rows("70:94").Select

Selection.EntireRow.Hidden = True

End Sub





Sub copy()

Sheets("staging").Select

Rows("1:189").Select

Selection.copy

Range("A1").Select





End Sub



Sub fix_x()

'



Sheets("staging").Select

Range("A1").Select

Application.CutCopyMode = False

ActiveCell.FormulaR1C1 = ""

Range("A1").Select

End Sub

I will try the cmd search. Thanks again Dave!

"Dave Peterson" wrote:

It may help if you posted the code, but I'd still look for the *.xlb files.

Windows start button|Run
cmd
(to get to a Command prompt)
c:
(to get to the c: drive)
cd\
(to get to the root directory)

Dir *.xlb /s
(to search for all the .xlb files on the c: drive)



Matt wrote:

I searched the whole computer and found no xlb files anywhere hidden or not.
Any other possibilities? Would it help if I posted the code? Thanks for the
help!

"Dave Peterson" wrote:

Just a guess...

One of the things that excel does when you close the program is update the
customized toolbar. Maybe you could try this:

Close excel
windows start button|Search
look for *.xlb in hidden folders and for hiddend files.

Rename all you find to *.xlbOLD

Then back to excel and test it. Open your file and make some changes. Then
close excel.

If it crashes, then this wasn't the problem. And rename your *.xlbOLD files
back to *.xlb.

If it works ok, then delete those *.xlbOLD files. You will have to rebuild any
customized changes you've made to your toolbars, though.

Matt wrote:

Hi Folks,
I have Excel 2003 updated on XP Pro updated. I have a VB object in my file.
All it does is copy and paste. It ends with a memory clearing. I close Excel
and it crashes. Here is what I found in the Event Viewer for Apps:

Faulting application excel.exe, version 11.0.8120.0, stamp 4578a992,
faulting module fm20.dll, version 11.0.8000.0, stamp 434ba62b, debug? 0,
fault address 0x000b1544.



For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

I have installed hotfixes FM2OFF and FM20op. Still happens. Anyone know what
to do? Thanks!

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson


--

Dave Peterson