In this article you are going to learn how to interact with HTML pages from Excel Macro/VBA. Though Excel is not much capable and easy enough to interact with HTML pages and its HTML controls. But up to some extend we can interact with HTML pages by Excel Macro. To...
Results for "tool"
How to Send an Email using Excel Macro from Gmail or Yahoo
Dear Readers, In this article, we are going to learn how to send an email automatically by Excel Excel VBA. While executing the Excel Macro, sometimes you may need to send some Details or Results directly to your email ID or any other ID using Excel Macro. If you have...
SQL Connection using Excel Macros
Dear Friends, Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. In this Article, I am going to teach you, how you can do a connection with a SQL Server. SQL databases has mainly two type of authentication : 1. Windows Authentication...
Hide Horizontal or Vertical Scrollbar in Excel Workbook
In one of the Article, I had shown how to hide or display the Horizontal and Vertical Scroll Bar of an Excel Workbook using Excel VBA code. Now here I am going to show how can we DISPLAY or HIDE, Horizontal or Vertical Scroll Bar in an Excel Workbook by choosing excel...
Oracle Connection String in VBA
Dear Friends, Using Excel Macros (VBA) you can connect to Databases like SQL, Oracle or Access DB. In this Article, I will teach you, how you can do a connection with a Oracle Server. We can do connection with Oracle either by giving SID (Oracle System ID) or Service...
Excel Macro Tutorial : Visual Basic Editor in Excel
Before starting with Excel Macro, we need to know, how to open Visual Basic Editor where one should write the code for Excel Macro. To go to Visual Basic Editor is different in a different version of MS Excel. Excel 2003 | Excel 2007 / 2010 How to Open VBE in Excel...
Macro Security
Macro security is used to help in activation of executable code written in Excel VBA. Unless Macro security is low or disabled, user can not run any of the executable code in Excel VBA. Macro Security setting is different in Excel 2003, 2007 and 2010. Here we will see...
Excel Macro Tutorial : How to add different types of controls like Text Box, Radio button, button etc. in Excel
Dear Readers, This is the 3rd Article of this Excel Macro Tutorial. In this Article, we are going to see How to add different types of controls like Text Box, Radio button, button etc. in to the Excel Follow the below Steps one-by-one to Add Controls in your...
How to disable/Invisible Horizontal/Vertical Scroll Bar
While developing some Excel VBA based tools in Excel, you might find this useful when you want to disable or enable horizontal or vertical scrolling in excel automatically. It is very easy to disable the Horizontal or Vertical Scroll bar using the VBA code. They are...
Buy a coffee for the author
Download FREE Tools and Templates
There are many cool and useful excel tools and templates available to download for free. For most of the tools, you get the entire VBA code base too which you can look into it, play around it, and customize according to your need.
What is Excel Formula?
Excel Formula is one of the best feature in Microsoft Excel, which makes Excel a very very rich application. There are so many useful built-in formulas available in Excel, which makes our work easier in Excel. For all the automated work, Excel Macro is not required. There are so many automated things can be done by using simple formulas in Excel. Formulas are simple text (With a Syntax) which is entered in to the Excel Worksheet Cells. So how computer will recognize whether it is a formula or simple text? Answer is simple.. every formula in Excel starts with Equal Sign (=).
FREE Download : Send Multiple Email Tool – Ver 3.0
First of all, I would like to thank you all for appreciating and giving the feedback about Send Multiple Email - VBA...
Spreading an Array values across Rows in Excel – VBA
This is an extension to my previous Article. Where we learned the best way to spread array values across columns in...
Spreading an Array values across Columns in Excel – VBA
All my avid readers from Computer Programming backgrounds must be thinking is it a big deal? Like other programming...