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

Tags

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)

 

 

 

BLOCK LAYOUT for SPEECH TO TEXT - APP INVENTOR

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