excel crash on workbook_open userform.show

[Spencer Hutton]

I have a userform.show statement running with the workbook_open event.
if i close my workbook and do not save, the next time i open it, i get the
error, path/file access error and then the vb error, could not find specified
object. does anyone know what causes this. every app i have written with a
userform.show statement on this event has never caused me a problem like
this...

 

[Dave Peterson]

A complete guess.

Try cleaning up your windows temp folder.

close excel
Windows start button|run
%temp%
and delete everything you can.

Sometimes, the mass of temp files confuses excel.

If that doesn't work, I'd try moving the code from workbook_open to Autpen
(in a general module).

If that didn't work, I'd try:

option explicit
sub Workbook_open()
application.ontime now + timeserial(0,0,1), "Continue_Open"
end sub

And create a
Sub Continue_Open()
'with your code
'in a general module
end sub

 

[Alan124]

A complete guess.

Try cleaning up your windows temp folder.

close excel
Windows start button|run
%temp%
and delete everything you can.

Sometimes, the mass of temp files confuses excel.

If that doesn't work, I'd try moving the code from workbook_open to Autpen
(in a general module).

If that didn't work, I'd try:

option explicit
sub Workbook_open()
  application.ontime now + timeserial(0,0,1), "Continue_Open"
end sub

And create a
Sub Continue_Open()
  'with your code
  'in a general module
end sub

Did this problem cause corruption of your excel files? If so, maybe
you can try a popular Excel file recovery tool called Advanced Excel
Repair to repair your Excel file. It is a powerful tool to repair
corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan