Excel

Excel Automation

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

Contributor
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

Create Custom Commands for Excel - VBA

Contributor
Submitted by techrev on Thu, 12/29/2016 - 09:49

Create Custom Commands for Excel - VBA

You can create Custom Commands for Excel to perform some predetermined operations. These commands can be entered directly inside a cell to do the required actions (calculations)

Please note that, these commands are made on VBA, so please refer our previous articles for the basic idea on Macros and VBA

Example Command : ADD

Command to ADD to values from columns A and B and display in C, the command “ADD” will be typed in cells of Column C

Steps :

Tags

How to insert a button in Excel (VBA)
How to insert a button in Excel (VBA) Excel Automation Tutorials
CAAadmin Wed, 07/20/2016 - 07:28

Tags