Create a cube in Solidworks VBA - Solidworks Automation

Submitted by techrev on Mon, 05/01/2017 - 11:10

The code for creating a simple cube in Solidworks with VBA (macros)

Edit X and Y and Z values for customization

Private Sub CommandButton1_Click()

Dim swApp As Object

Dim Part As Object

Dim boolstatus As Boolean

Dim longstatus As Long, longwarnings As Long

Set swApp = Application.SldWorks

Set Part = swApp.ActiveDoc

Dim myModelView As Object

Set myModelView = Part.ActiveView

myModelView.FrameState = swWindowState_e.swWindowMaximized


Arduino Stepper Motor Pin Config and Code

Submitted by techrev on Sun, 04/30/2017 - 08:13

Arduino and Stepper motor pin configuration

arduino stepper pin config

I/O Connect to Controller : to pins 8, 10, 9, 11

Use below program  for your stepper motor driver trials

#include <Stepper.h>
#define STEPS 32   
#define STEPSREV 32 * 64  //2048  

Stepper stepper1(STEPS, 8, 10, 9, 11);

int  Steps2Take;

void setup()  



Read the value of a cell from another excel file without opening it

Submitted by techrev on Sat, 04/29/2017 - 07:58

You have an excel file at location D:\ (example D:\fromdata.xlsx ) and you want to read its cell value E2 and put it inside the file located at C:\ (example C:\todata.xlsx )

Open your file at C:\todata.xlsx go to Developer Tab and then insert a button










excel automation