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

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)

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