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!

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

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
>

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

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
>

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

Matt,
It generally not advisable to use words that Excel/VBA employ.
Change the name of "copy" routine to something else, e.g. "MyCopy".

NickHK

"Matt" <(E-Mail Removed)> wrote in message
news:624351A1-F126-4685-A825-(E-Mail Removed)...
> 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
> >

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
>

Hey Nick! thanks for the tip on the "copy" idea, but still crashing when
closing Excel. I asked Dave for EVERYTHING that occurs when closing Excel so
I can compare it to the code and anything else to see what happens. By the
way, this problem does not occur in Office 2007, but we need it to work here
as well which is DID just a couple weeks ago. Nothing has been changed about
the files and I have tried uninstalling Office and reinstalling without
adding updates in case they were causing trouble. We are officially stumped.
Thanks for the help!

"NickHK" wrote:

> Matt,
> It generally not advisable to use words that Excel/VBA employ.
> Change the name of "copy" routine to something else, e.g. "MyCopy".
>
> NickHK
>
> "Matt" <(E-Mail Removed)> wrote in message
> news:624351A1-F126-4685-A825-(E-Mail Removed)...
> > 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
> > >
>
>
>

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