Pages

▼
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:

VBA Send File to Recycle Bin

›
Delete Files using VBA There are many methods to delete the file:- simple VBA Kill method, using FileSystemObject etc. Here is one snippet m...
3 comments:
Tuesday, July 29, 2008

Identify Objects that are linked to Source file using Excel VBA

›
Extract all Linked Objects in Excel Spreadsheet using VBA At times when you send out some document, you should be careful of the e...

Embed Existing Word File to Spreadsheet using Excel VBA

›
Insert Existing File (Word Document) to Spreadsheet using VBA Sub Insert_File_To_sheet() Dim oWS As Worksheet ' Worksheet Object Dim oOL...
1 comment:

Embed Word Document to Excel Sheet using Excel VBA

›
Programming OLEOBjects in VBA to embed Word Document Sub Embed_WordDocument_To_sheet() Dim oWS As Worksheet ' ...

Add Words to AutoCorrect Entries

›
AutoCorrect feature is used to correct typos and misspelled words (dont to don’t), as well as to insert symbols ((c) as ©) and other piec...
1 comment: