Sunday, August 23, 2015

Can I execute batch file by excel VBA ?

Creating and executing batch file is very useful way for project automation. It is very comprehensive to create complex automation. you can use batch file with excel VBA combination for several operations.


Friday, August 21, 2015

How to get system info using excel vba

In some situations user need to know system information to automate their excel VBA automation. So, the users comes with below question.

Can I get System Info by Excel VBA ?


and the answer for this is "Yes"

Thursday, August 20, 2015

How to show VBA code execution status information on excel statusbar

There are several situations where we need to know execution status of macro code. we can show status of macro execution in excel status bar. Below block of code will help you to do this.