Pages

▼
Monday, January 30, 2012

How to Extract Comment information from Word VBA

›
How to Extract Comments Text and Related Information from Word Document using VBA Here is a hint of accessing the comments and related inf...
4 comments:

How to Identify and Tag Numbered Lists using VBA

›
How to Identify and Tag Bullet Lists using VBA Following snippet identifies a Bulleted List and Tags all Bullet List items and the Bullett...

Compare Word Documents with Headers and Footers using VBA

›
How to Compare Word Documents Programatically using Word VBA Word Documents are everywhere .. proposals, tenders, notes, technical papers....

How to Convert Word Table to PDF using VBA

›
Export Word Table as PDF using VBA Anyone who is using Word for quite sometime will agree that Tables and Images are bit scary when it com...

How to Export Parts of Document using Word VBA

›
Copy Content with Formatting to New Document using Word VBA Not all the tens and hundreds of pages in a Word document interests you or mat...
1 comment:

How to Format Part of Content Controls in Word VBA

›
Word VBA - Format Some portion of Rich Text Content Control Programatically ContentControls have become ubiquitous with Word documents now...
Sunday, January 29, 2012

How to Search and Highlight/Tag a string in Word VBA

›
How to Search Content for Specific String/Text using Word VBA This action is performed often by programmers - there are couple of ways to ...
Saturday, January 21, 2012

How to create a Trendline Chart using Excel VBA

›
Excel VBA - Trendline Charts Here are some snippets useful to create a TrendLine Chart in Excel Have used the entire data from the given...
Sunday, November 06, 2011

How to Extract Properties from Excel/Word without Opening File using VBA

›
How to get CustomProperties from Excel Workbook/Word Document (VBA) without physically opening the file There are many cases where we nee...
Tuesday, September 06, 2011

How to link Excel Table to ListBox using VBA

›
Fill a ListBox from Excel Table using VBA / Populate a ListBox from Excel Table using VBA Let us take a Excel table as shown below - a lis...
Wednesday, May 25, 2011

How to XCOPY files using VBA

›
How to copy set of files from one folder to another using VBA / How to run DOS Commands in VBA After a long hibernation I am posting in th...
1 comment:
Sunday, September 12, 2010

How to copy RichTextBox contents to Word document

›
How to insert Rich Text Box Content to Word document using VBA Let us have a form with a RichTextBox and a Command Button as shown below ...
4 comments:
Wednesday, August 25, 2010

How to edit Linked Objects using Word VBA

›
How to open and edit Linked Excel files from Word using VBA One can insert an object in word by either linking or embedding. We have alrea...
1 comment:
Saturday, August 21, 2010

Hide Sheet Tabs using VBA / Hide Excel Sheet Tabs (2007/2010)

›
How to Hide Excel Sheet Names using VBA If you want to hide the Sheet Tab (as shown below) you can do that using Excel Options Hide / Un...
5 comments:
Friday, August 06, 2010

How to Read Excel Sheet embedded in Word Document using VBA

›
How to edit Embedded Objects (Excel Workbook) using Word VBA In our previous posts we have seen how to Embedd an Word Document in Excel Ob...
9 comments:

How to Extract All Formula's in Excel Sheet using VBA

›
Highlight all cells containing Formulas using Excel VBA The following snippet highlights all cells that contain formula Sub HighLight_Fo...
1 comment:
Wednesday, August 04, 2010

How to Connect XLSX file (Excel Workbook) through ADO

›
Using Excel (Xlsx) file as a database using VBA (ActiveX Data Objects - ADO) In the past we have already seen how to Connect to an Excel f...
2 comments:
Tuesday, July 27, 2010

Excel VBA Autofilter - Specify Multiple Criteria using Array

›
How to pass an Array as Criteria in Excel Autofilter - VBA After long time let us revisit our good old Autofilter Fruits example . The fol...
9 comments:
Sunday, July 25, 2010

Program/Macro to Highlight Editable Ranges in Protected Sheet

›
How to identify Editable ranges in a protected Excel sheet using VBA My good friend Srikanth Srinivasan is a Project Manager whom Microsoft...
1 comment:
Friday, July 23, 2010

How to retrieve value from Content Controls using Word VBA

›
The following snippet validates the user selection using VBA. This code uses the content control created in previous example - ( How to add ...
3 comments: