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

AutoCAD VBA - user promt example
AutoCAD VBA User prompt example
techrev Sun, 04/23/2017 - 09:50


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

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)





techrev Thu, 03/30/2017 - 10:27
Record a Solidworks macro - Solidworks Automation

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

techrev Thu, 03/09/2017 - 09:59