Pages

▼
Tuesday, September 30, 2008

Add Macro to Workbook programatically using Excel VBA

›
How to Add Macro to Workbook using Excel VBA Here is a simple procedure to add a macro to the current workbook using VBComponents Sub Add_Ma...
1 comment:
Wednesday, September 17, 2008

Add Controls Popup Menu using Powerpoint VBA

›
Powerpoint Application - Create Popup menu using VBA The following code is a simple one to create popup menu in Powerpoint using VBA Sub Add...
Saturday, September 06, 2008

Opening Comma Separate File (CSV) through ADO

›
Sort CSV File through Excel VBA ADO/ Open CSV File using ADO CSV files are easy way of storing data apart from XML files. There are many tim...
4 comments:

Convert Excel Comments to Text using VBA

›
VBA Copy comments to a Range in Excel If a worksheet is dotted with lot of comments and you want to respond to each one of these, it is bett...
17 comments:
Thursday, August 21, 2008

Visual Basic Script to Lock Computer

›
Lock Machine (Computer) using VB Script My good friend Venugopala Reddy Ragi had a good VBScript snippet to lock computer. Probably useful f...
5 comments:
Tuesday, August 12, 2008

Play Audio File using Excel VBA

›
Play Audio File using Excel VBA / Excel VBA Play Wav File Here is a small snippet used by Pradeep Meesala to play a wav file. He has used th...
5 comments:

Permanently hide worksheet from user using VBA

›
Hide / Unhide Worksheets using Excel VBA (Excel 2007) Here is the simple code to Hide and unhide Worksheet: Sub Hide_Unhide_Worksheets() ...

Get Name of the WeekDay (Excel VBA)

›
Get Name of the WeekDay (Excel VBA) Sub WeekDay_Name() Debug.Print(WeekdayName(1)) Debug.Print(WeekdayName(1, True )) Debug...

Retrieve / Get First Row of Excel AutoFilter using VBA

›
Extract First Row of the Filtered Range using Excel VBA We can create filters programmatically using Excel VBA ( AutoFilter using Excel VBA ...
5 comments:

Create AutoFilter with Multiple Criteria using Excel VBA

›
Excel VBA Applying Multiple Criteria in AutoFilter Here is a simple way of using multiple criteria in the Excel AutoFilter option Sub AutoF...
14 comments:

AutoFilter using Excel VBA

›
AutoFilter using Excel VBA Filters are one of the most used Excel utilities. Here is a simple way to create a filter through code Sub Simp...
11 comments: