Excel crashing every time I open a userform on a workbook.

[RockandGrohl]

This hasn't ever happened to me in the year I've been using this sheet.

I applied some changes a few days ago and it was working fine.

I applied some more changes yesterday and it was working fine.

I also applied some changes an hour ago and it was working fine.

I've now gone to use the sheet again and every time I load a userform, I get an Appcrash with the following:

Problem Event Name:    BEX64  Application Name:    EXCEL.EXE
  Application Version:    14.0.6024.1000
  Application Timestamp:    4d83e39d
  Fault Module Name:    unknown
  Fault Module Version:    0.0.0.0
  Fault Module Timestamp:    00000000
  Exception Offset:    0000000000000000
  Exception Code:    c0000005
  Exception Data:    0000000000000008
  OS Version:    6.1.7601.2.1.0.256.48
  Locale ID:    2057


Additional information about the problem:
  LCID:    1033
  skulcid:    1033

Not amazingly verbose.

What's happened and how do I troubleshoot this?

The code behind the userform is pretty weighty (and always has been) but it's never crashed like this.


In fact, I just clicked on the backup portal's userform and it also crashed excel.


This also crashed a colleagues excel... Now I'm worried.

EDIT

This is crashing when the code gets to the part where it opens an external csv.

The whole app crashes and must be restarted.

I repeat, this was working fine an hour ago and there has been no change to the code since.

In addition, one of the backed up portals with no recent changes to it whatsoever is now also crashing.

 

[Logit]

This is crashing when the code gets to the part where it opens an external csv.

Does the csv exist ?

Was it moved ?

Is the path in the code pointing to the csv still accurate ?

Is there something wrong with the csv ?


Since the error is pointing at the csv ... concentrate on that first.
Also, what error message is given, if any ? Not what you have already posted but an error message.

 

[RockandGrohl]

Does the csv exist ?

Was it moved ?

Is the path in the code pointing to the csv still accurate ?

Is there something wrong with the csv ?


Since the error is pointing at the csv ... concentrate on that first.
Also, what error message is given, if any ? Not what you have already posted but an error message.

Hiya.

CSV is fine, the code that references and opens the CSV is identical to another workbook which works absolutely fine.


I just ran the "CleanControlNames" code provided here

https://www.mrexcel.com/forum/excel-questions/898098-excel-2013-crashing-issues.html


And it's working... Miraculously..

 

[RockandGrohl]

Just to note we have 4 reader offer portals


"Reader Offer Portal"

"Reader Offer Portal - JG"

"Reader Offer Portal - OM"

"Reader Offer Portal - Dev"

Last week I copied the regular portal and created the Dev one from the copy. Have been amending some code in this, it's been working fine until now when it's stopped.

I haven't touched JG, but JG is exhibiting the same issues.

OM and the regular Reader Offer Portal are working perfectly.

 

[Logit]

Glad you found a solution !

Cheers.