Pages

▼
Saturday, January 25, 2014

How to Extract Wild Card Matches in Word Document using Word VBA / Export Find Matches to Text File using VBA

›
How to use Word VBA to Find Wild Card Matches in Multiple Word Documents and Extract them  There are many situations where a particular ...
5 comments:
Monday, October 14, 2013

How to Login to a HTTPS Website PopUp using Excel VBA

›
Control Login Popup from Excel VBA  The new HTTPS popups cause lot of irritation to the developers who have coded for it before...
1 comment:
Sunday, May 26, 2013

Convert PowerPoint TextBox Slides as Notes using VBA

›
How to Add Notes to Powerpoint Slides using VBA It has been quite some time since I posted in this blog. Murugan had kindl...
Friday, May 11, 2012

How to Save PowerPoint Presentation as PDF using VBA

›
How to Convert PowerPoint Presentation PPT to PDF using VBA PDF is always the universal format for sending the files. With lot of versions...
5 comments:
Sunday, May 06, 2012

Excel VBA TimeStamp – Milliseconds using Excel VBA

›
How to Get Time in Milliseconds using Excel VBA The following function uses Timer function to get the milliseconds and append it to the c...
1 comment:

Excel VBA uninstall Excel Addins

›
Programmatically uninstall Excel Addins using VBA Sub UnInstall_Addins_From_EXcel_AddinsList() Dim oXLAddin As AddIn For E...
3 comments:

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 '...
4 comments:

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 () and also add mul...

UnInstall Word Addins using VBA

›
Here is a simple method to uninstall a Word Addin (.dot file) using Word VBA Private Sub UnInstalled_AllWordAddins() ...

Word VBA add command buttons through code

›
Add CommandButton to Word Document using VBA (through AddOLEControl) Here is one of the ways to add a command button on a Word document u...
3 comments:

Update Word Document with Excel Information using VBA

›
Excel Range to Word Template using VBA Most often we maintain list of contacts in Excel workbook and it needs to be transferred to Wor...
1 comment:
Wednesday, May 02, 2012

How to Make a File ReadOnly using Excel VBA

›
How to Create ReadOnly Files using VBA - Excel VBA ReadOnly Function There are many occassions where you want to save the file as Readonly...
1 comment:
Wednesday, February 29, 2012

How to Create Hyperlinks in multiple cells using EXcel VBA

›
How to Link Cells to Files/Folders using Excel VBA There are many cases where we want to have a Hyperlink on a cell that opens a document ...

How to Split Text in a Cell to Multiple Cells using Excel VBA

›
Convert a Text to Range using Excel VBA The following snippet converts the Text to an Array by splitting using SemiColon delimiter and use...
3 comments: