Monthly Archives: June 2013


Data Analysis – An Introduction

Data Analysis is important to every organization to survive in this competitive world. In recent years every one wants make use of data available to understand their business to take effective decisions. I spent around 10 years in analyzing the data. And played different roles to help my clients to take effective decisions. In this topic I am going to discuss the basics of data analysis to give an overall idea about Data Analysis.

In this topic:
  • What is Data Analysis?
  • Why do we need Data Analysis?
  • Approach to do Data Analysis
  • Different kinds of Data Analysis - By Request
  • Different kinds of Data Analysis - By Domain
  • Useful Links for Data Analysis

Interacting with Other Applications using VBA

We can interact with the other applications using VBA - with the MS Office Applications like Word, PowerPoint,Outlook,etc... and other applications like Internet Explorer, SAS,etc.

In this Section:
  • Introduction?
  • How to interact with MS Word? - Late Binding
  • How to interact with MS Word? - Early Binding
  • How to interact with PowerPoint? - Early Binding
  • How to interact with Outlook? - Late Binding
  • Example File

VBA Security in Excel

It is important to understand the macro security if you are dealing with the Macro Enabled Files. It helps to protect your data from the malicious programs and helps to know how to run the macros when its required.

In this Section:
  • Understanding VBA Security
  • What are the different Levels of the Security in VBA?
  • How to Enable or Disable the Macros?
  • How To Protect VBA Code?

Related pages

vba popup windowmerge cells microsoft excelextract url from hyperlink excelddl sql commandsiferror excel vbavba adodb recordset examplesumifs excel examplems excel vlookup functionvba print worksheethow to create dashboard in excel 2007logical function in excelapplication.enableeventsvb6 checkboxvba paste from clipboardexcel unprotect without passwordmicrosoft excel 2010 pivot table tutorialexcel add multiple rowsaverageifs in excelmsgbox buttonshow to insert macro button in excel 2010vba createtextfileprotect sheet excelselect vba exceloutlook.application vbahow to use lookup function in excel 2010define macro in excelunprotect a workbook without passwordvlookup with truemacro to delete columnsopen excel from access vbadelete row in excel vbalearn macrosvlookup uses examplesvlookup function helpenable macros in vbaexample for vlookupvba dim as stringexcel remove blank rowsvba sort rangeexamples for vlookup in exceladodb.connection connection stringexcel vba intfinding doubles in excelhow to unhide all worksheets in excelhlookup in exceldelete duplicates on excelexcel vba form examplesexcel row widthdonut chart generatorcell interior color vbablank checks worksheetwhat are ddl statementsexcel vba close filevba export excelcells.find vbadefine macro in excelexcel vba file openvba selection.deletefaq testing interview questions answersvba case functionremove excel workbook protectionadvanced vlookupexcel 2007 merge cellslist box controldashboard creation in exceldelete columns vbajob costing excelhow do i lock excel spreadsheethow do you remove duplicate rows in excelvba word range