Tutorial on Pivot Table – Part 1

Rating 3.00 out of 5 [?]On first day at work, I was given an excel workbook that was used to test the reports which are generated using a software and are delivered to the client. The workbook had a large amount of data, kind of a database in itself and … Continue reading

Sending Email With Picture Using Outlook through Excel VBA Macro

Rating 4.50 out of 5 [?]One of my collegues wanted me to write an Excel VBA Macro to send same or similar (differing in the salutation, etc) emails taking one address at a time which he has added in an MS-Excel file. So in short, we need a program that … Continue reading

Copying Chart from MS-Excel 2007 to MS-Powerpoint 2007 Using Excel VBA

Rating 4.33 out of 5 [?]This excel macro will export all the charts from the activesheet of excel workbook to a new PowerPoint presentation. If there are 4 charts on Sheet 1 of the excel workbook, then they will be pasted on separate slides in the PowerPoint presentation in each … Continue reading

Running Teradata Queries From MS-Excel 2007 Using VBA

Rating 3.80 out of 5 [?]Here is a simple tutorial to connect to a Teradata database system using Teradata ODBC driver and manipulate data using VBA and ActiveX Database Objects(ADO). This can be used to automate some of your task like running queries multiple times. First of all, we have … Continue reading

Export Picture from Excel 2007 to PowerPoint 2007

Rating 4.00 out of 5 [?]I have been working on a lot of MS-Excel macros and I am going to share one small tutorial on how to copy and paste an image/picture from an excel sheet to power point presentation. Following is the VBA code to carry out the same. Copy and … Continue reading

Embedding Shockwave Flash in MS-Office Applications

Rating 3.00 out of 5 [?]Flash Games are generally blocked in your office network. But at times we want to bust stress and flash games are way to go 🙂 … Here is a small tutorial that will help you embed a shockwave flash file in MS-Office applications like MS-Excel … Continue reading