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

excel macro writingms access vba export query to excelsumifs vbadata analysis tab in excel 2007excel vba toolssplit function in excel vbaproject management timeline template excelfor each loop vbaadodb connection exampleremove duplicate entries from excelremove hyperlinks in excelmulti selection listboxvba rowmacro to delete blank rowsunload me vba excelunmerge cell excelproject tracking with excelms excel rowsshortcut keys of excel 2007vba code dimdashboard powerpoint templateinsert rows in excel shortcutexcel arrange in ascending orderexcel button for macrosample excel macro programsexcel pivot chart tutorialvba proceduresshort cut key excelapplication vlookupsql questions and answers for experiencedvba copyfileexcel macro userformxlsm file downloadvlookup and hlookup tutorialdeveloper mode excel 2010excel count formulaswhat is meant by vlookupproject portfolio dashboard excelexcel formula for alphabetical orderworksheetfunction sumhow do you count rows in excelhow to hide excel rowsexcel vba rowsexcel match typeexcel activeworkbookforgot unprotect sheet passwordformula replace excelexcel vba learninghow to add columns in excel 2007excel vba print userformvba combobox excelfso rename fileunprotect powerpointvlookup simplevba empty cellvba protect workbookvba on errorformula in pivot table excel 2010for each vba excelexcel project management spreadsheetvlookup advancedmysql dsn connection stringvba dim variableexcel if statement examples textvba excel select caseexcel vba codesql interview question pdfvb arrayscombobox excel vbainsertrange