Skip navigation

41 Replies Latest reply on Dec 27, 2017 11:38 AM by Deepak Gupta

SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Raumik Rana Oct 13, 2017 10:51 PM

I RECENTLY STARTED LEARNING SOLIDWORKS VBA.

WHENENVER I WANT TO ADD USERFORM IN THE VBA CODE

SOLIDWORKS CRASHED EVERYTIME.

solidworks crash1.avi 11.6 MB

Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Christian Chu Oct 13, 2017 1:29 PM (in response to Raumik Rana)
Raumik,
Can you post your macro here? there is no reason SW crashes while adding a userform?
EDIT: can you download the att. macro and run
if no crash, you can use it for your macro

AddUserForm.swp.zip 8.7 KB
Like Show 3 Likes(3)

Actions
- Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
  
  Raumik Rana Oct 13, 2017 1:36 PM (in response to Christian Chu)
  
  Hi, christian chu.
  thanks for replying so fast to my problem.
  here,
  when i am tried to run your macro,
  I got an error as you can see in image.
  "a serious errpr occured on open macro file.
  the system could be in an unstable state now."
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
    
    Christian Chu Oct 13, 2017 1:40 PM (in response to Raumik Rana)
    
    Before running the macro, can you go to Tools pulldown menu and select References.... and capture image and post here - see below image
    
    Like Show 4 Likes(4)
    
    Actions
    - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
      
      Raumik Rana Oct 13, 2017 1:48 PM (in response to Christian Chu)
      
      Like Show 1 Likes(1)
      
      Actions
      - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Jacob Corder Oct 13, 2017 2:28 PM (in response to Raumik Rana)
        
        Christian Chu is showing you that you need to check Microsoft Forms 2.0 Object Library. you need to add this reference
        
        Like Show 1 Likes(1)
        
        Actions
      - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Christian Chu Oct 13, 2017 4:45 PM (in response to Raumik Rana)
        
        Thank you, Jacob
        Raumik,
        You need to load the Microsoft obj. lib. so so can add window form to your macro
        
        Like Show 3 Likes(3)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 13, 2017 9:05 PM (in response to Christian Chu)
        
        Thanks Christian chu,
        Can you please tell me how to do that?
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Christian Chu Oct 14, 2017 12:03 AM (in response to Raumik Rana)
        
        Roll the bar down find and check Microsoft Form 2.0 Object Library - see below image
        
        Like Show 3 Likes(3)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 14, 2017 11:54 AM (in response to Christian Chu)
        
        there is no reference like that in list
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 13, 2017 10:44 PM (in response to Christian Chu)
        
        i tick that but same problem occurs.
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 13, 2017 10:52 PM (in response to Christian Chu)
        
        hi,
        please see the video i attached to original post.
        
        Like Show 1 Likes(1)
        
        Actions
Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Deepak Gupta Oct 14, 2017 3:09 AM (in response to Raumik Rana)

What is SP of your SOLIDWORKS?

Also please refer to this article : Instability in SOLIDWORKS due to conflict with Microsoft KB3072630
Like Show 1 Likes(1)

Actions
- Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
  
  Raumik Rana Oct 14, 2017 12:01 PM (in response to Deepak Gupta)
  
  SP02
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
    
    Deepak Gupta Oct 14, 2017 1:30 PM (in response to Raumik Rana)
    
    Can you try reinstalling SOLIDWORKS or check if that KB affects your machine?
    
    Can you try to replicate the issue on some other machine?
    
    Like Show 1 Likes(1)
    
    Actions
    - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
      
      Raumik Rana Oct 15, 2017 8:29 AM (in response to Deepak Gupta)
      
      i reinstall solidworks but same problem .
      I also tried to other machine , it is working fine in other pc.
      Sorry , but how to check KB affects or not my machine?
      
      Like Show 1 Likes(1)
      
      Actions
      - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Oct 15, 2017 8:43 AM (in response to Raumik Rana)
        
        Raumik Rana wrote:
        
        i reinstall solidworks but same problem .
        I also tried to other machine , it is working fine in other pc.
        Can you import SOLDIWORKS settings from that other machine and check again?
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 15, 2017 9:02 AM (in response to Deepak Gupta)
        
        i do that.
        but same problem.
        can you send me other setting so i can check with that?
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Oct 15, 2017 11:23 AM (in response to Raumik Rana)
        
        Can you please report this your VAR and send them the Rx file from your machine?
        
        Like Show 2 Likes(2)
        
        Actions
Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Jacob Corder Oct 16, 2017 5:21 PM (in response to Raumik Rana)

MrExcel Message Board

You need to follow these steps .
Click Browse

Go To C:\WINDOWS\system32
Search For FM20.DLL
select
Like Show 4 Likes(4)

Actions
Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Jacob Corder Oct 16, 2017 5:23 PM (in response to Raumik Rana)

if it doesnt exist go to

Control Panel

Click on Turn Windows Features On or Off
make sure .net framework 3.5 (Includes .net 2.0 and 3.0) is checked like this
Like Show 4 Likes(4)

Actions
Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Christian Chu Oct 16, 2017 6:24 PM (in response to Raumik Rana)

Raumik,
Seems to me that you didn't follow any help we provided here. I watched the video and didn'tsee you rolled the bar down to find the Microsoft obj. Lib.
I think it's best to contact your VAR so they can go thru all steps with you
And also you need to get some basic knowledge of windows and VBA before proceeding a macro - trial and error won't get you anywhere !
Like Show 3 Likes(3)

Actions
- Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
  
  Raumik Rana Oct 16, 2017 10:46 PM (in response to Christian Chu)
  
  yes,
  but after that i browsae fm20.dll and tick microsoft forms 2.0 object library.
  
  Like Show 0 Likes(0)
  
  Actions
  - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
    
    Ivana Kolin Oct 17, 2017 7:04 AM (in response to Raumik Rana)
    
    uncheck solidworks utilities 2015 type library
    
    Like Show 2 Likes(2)
    
    Actions
  - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
    
    Jacob Corder Oct 17, 2017 10:14 AM (in response to Raumik Rana)
    
    Ok.. So did it work now?
    
    Like Show 1 Likes(1)
    
    Actions
    - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
      
      Raumik Rana Oct 17, 2017 12:00 PM (in response to Jacob Corder)
      
      no
      is there any problem with windows ?
      
      Like Show 0 Likes(0)
      
      Actions
      - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Oct 17, 2017 12:27 PM (in response to Raumik Rana)
        
        Can you share you screen over Team Viewer to see if the issue can be debugged? If yes then PM me.
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 17, 2017 3:03 PM (in response to Deepak Gupta)
        
        Ya sure.
        But maybe tomorrow.
        
        Like Show 0 Likes(0)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 18, 2017 5:55 AM (in response to Raumik Rana)
        
        I add another user account to pc.
        and install solidworks in that account.
        it works fine and i can add userform in vba.
        thanks you so much all of you.
        
        Like Show 2 Likes(2)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Oct 18, 2017 5:59 AM (in response to Raumik Rana)
        
        So that signifies issue with your SW install. Thanks for sharing the method which worked for you.
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Raumik Rana Oct 18, 2017 6:04 AM (in response to Deepak Gupta)
        
        you welcome Sir.
        Can you please guide me to learn programming for solidworks.
        I am mechanical engineer and have experience of 2 years in solidworks.
        Now i want to learn something more about solidworks and macro.
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Oct 22, 2017 5:45 AM (in response to Raumik Rana)
        
        Check replies in this post: https://forum.solidworks.com/message/364355#comment-364355
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Mathieu Jette Oct 23, 2017 2:27 PM (in response to Deepak Gupta)
        
        Hello Deepak,
        I'm having the same issue than Raumik about the userforms. I'm running SW2015 on Win10 PRO.
        I was able to get the "Microsoft Forms 2.0 Object Library" reference loaded but the crash still occured.
        What course of action would you recommend me to fix the issue, considering that my user is registered on a domain and I can't just create a new one.
        
        I'm figuring I should uninstall Solidworks (wich I did many times already trying to fix the issue) and then clean some folders in the %appdata% area. If you would give me some pointers I would appreciate.
        
        Thank you.
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Nov 12, 2017 1:45 PM (in response to Mathieu Jette)
        
        Mathieu, sorry for a delayed response. Can you try running SOLIDWORKS in Bypass mode and then try the userform?
        
        For bypass mode, open SOLIDWORKS Rx tool and use the bypass mode.
        
        Other option is to reinstall .NETFrameWork and check.
        
        Further open Excel and insert a new macro with a userform and see if that works fine or not.
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Dave Branco Nov 30, 2017 2:46 PM (in response to Deepak Gupta)
        
        Deepak,
        We have been having the same issue on one of our machines here. It has windows 10 on it but another computer with windows 10 works fine. We tried, re-installing the .net framework. We tried runing in the various safe modes as you suggested, we tried removing SolidWorks entirely from the computer and reinstalling as a stand alone installation (the original was installed with an admin image). Excel macros with userforms work fine. So far my VAR has not come up with a solution based on my Rx Captures either. Do you have any other idea what to try?
        
        Like Show 2 Likes(2)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Nov 30, 2017 10:52 PM (in response to Dave Branco)
        
        Dave, any chance if you have MS office 35 installed?
        
        Like Show 1 Likes(1)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Dave Branco Dec 7, 2017 4:12 PM (in response to Deepak Gupta)
        
        Deepak, No but I just heard back again from SolidWorks Tech support and they have given me a fix. From their email:
        #1: Install/reinstall certain prereqs that come bundled with SolidWorks. Please see attached for a list, you can find these under <SW DVD Download>\Prereqs
        
        #2: This is related to a recently discovered bug, documented in SPR 1053482 "SOLIDWORKS crashing upon inserting a userform in macro, or running macro with form in it."
        
        1. Close SOLIDWORKS
        2. Open Windows Explorer and Browse to %appdata%\Microsoft\forms and rename 'sldworks.box'
        
        ---
        This did the Trick for me (see .png attached for where to find .msi and .exe files to uninstall/reinstall!)
        
        VBA Prereqs.png 27.1 KB
        
        Like Show 3 Likes(3)
        
        Actions
        
        Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
        
        Deepak Gupta Dec 8, 2017 12:48 PM (in response to Dave Branco)
        
        Thanks Dave for sharing, might come in handy.
        
        Like Show 1 Likes(1)
        
        Actions
Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Lee Wilcken Oct 23, 2017 12:01 PM (in response to Raumik Rana)

I am experiencing this same issue. A coworker of mine also has the same problem. Perhaps a Windows update is causing it? I followed all the above advised steps. including a fresh reinstall of SW. Oddly enough adding a new user account to my PC also fixed the issue for me. I did not have to install SW for that user though.
Like Show 1 Likes(1)

Actions
Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?

Dave Branco Dec 7, 2017 4:15 PM (in response to Raumik Rana)
For anyone still experiencing this problem :
I just heard back again from SolidWorks Tech support and they have given me a fix. From their email:
#1: Install/reinstall certain prereqs that come bundled with SolidWorks. Please see attached for a list, you can find these under <SW DVD Download>\Prereqs

#2: This is related to a recently discovered bug, documented in SPR 1053482 "SOLIDWORKS crashing upon inserting a userform in macro, or running macro with form in it."

1. Close SOLIDWORKS
2. Open Windows Explorer and Browse to %appdata%\Microsoft\forms and rename 'sldworks.box'

---
This did the Trick for me (see .png attached for where to find .msi and .exe files to uninstall/reinstall!)

VBA Prereqs.png 27.1 KB
Like Show 1 Likes(1)

Actions
- Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
  
  Chris Mackedanz Dec 27, 2017 9:09 AM (in response to Dave Branco)
  
  You mention renaming 'sldworks.box' but what are you renaming it to?
  
  I'm also having this problem of SolidWorks crashing when inserting a userform.
  
  We purchased 4 new desktop machines with identical hardware and 3 identical laptops. I've been able to reproduce this problem on 2 of the desktops (users haven't been around to test on the other two ) consistently but NOT on the laptops. The laptops have NO problems adding a userform.
  
  I do know that the Microsoft Forms 2.0 object library is NOT listed on the desktops under the references dialog. I CAN however add it using the browse button but it still crashes when adding a userform.
  
  Also another possibly weird thing is that we have some macros which ALREADY contain a userform (and weren't working for sometime on all of the machines due to a corrupt userform that I re-wrote the code to not use any more) these recovered macros containing a userform run with out problems right now.
  
  FYI System info
  Windows 10, SolidWorks 2017 SP4
  
  Like Show 1 Likes(1)
  
  Actions
  - Re: SOLIDWORKS CRASHES WHEN I AM INSERTING USERFORM IN VBA ?
    
    Deepak Gupta Dec 27, 2017 11:38 AM (in response to Chris Mackedanz)
    
    Chris Mackedanz wrote:
    
    You mention renaming 'sldworks.box' but what are you renaming it to?
    Just rename to anything such that this file is created again (just my thought)
    
    Like Show 1 Likes(1)
    
    Actions

Go to original post

More Like This