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

Convert voice commands to text in Android App Inventor (for our Arduino Projects)

Submitted by techrev on Thu, 03/30/2017 - 10:27

To convert voice commands to text in Android app development (app inventor)

Drag Speech recognizer (from Palette/Media)  + 1 button + 1 label

please use below Block Layout to connect all those controls

then start your application and say something, you can see Speech to text conversion at Label

These commands can be used to Control Arduino (in later updates)





Record a Solidworks macro - Solidworks Automation

Submitted by techrev on Thu, 03/09/2017 - 09:59

Record a Solidworks macro

In this example we will discuss about “How to Record a Macro in Solidworks”

Open the Solidworks, Go to Tools -> Macro -> Record

solidworks mac

Then start your project, in this example we will be making a cylinder (Draw circle and extrude it to Cylinder)

Create a New Part Document