• 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