• Welcome to engineeringclicks.com
  • Solidworks : VBA : Excel Functions

    Discussion in 'SolidWorks' started by Jacques Grobler, Sep 20, 2012.

    1. Jacques Grobler

      Jacques Grobler Member

      Joined:
      Aug 2012
      Posts:
      8
      Likes Received:
      0
      Morning all

      I am wondering if this is the right place to post this thread...

      I am trying to use Excel fucntions in code that I am writing for VBA in Solid Works, but am failing miserably...

      Does anyone know where I can find any advise?
       
    2.  
    3. Matsui21

      Matsui21 New Member

      Joined:
      Oct 2012
      Posts:
      2
      Likes Received:
      0
    4. gupta9665

      gupta9665 Well-Known Member

      Joined:
      Mar 2010
      Posts:
      64
      Likes Received:
      0
      Would you mind sharing the codes and issues you facing.
       
    5. Jacques Grobler

      Jacques Grobler Member

      Joined:
      Aug 2012
      Posts:
      8
      Likes Received:
      0
      For example the ceiling function. I know I can use it in excel vba but I can for some reason not reference it in Solidworks vba.

      I am trying to calculate the sides of a sqaure based on some values being put in by the user, but the lengths must be based on increments of 5mm for example.
       
    6. Jacques Grobler

      Jacques Grobler Member

      Joined:
      Aug 2012
      Posts:
      8
      Likes Received:
      0
      Oooh, that's how...

      Tools > References > Microsoft Excel...
       

    Share This Page

    By using this website you agree to our Cookies usage. We and our partners operate globally and use cookies, including for analytics, personalisation, ads and Newsletters