Pages

▼
Monday, March 29, 2010

How to clean Office Solution - .NET

›
How to clean Office Solution from Visual Studio / How to unistall Excel/Word addins using Visual Studio Use the clean option in Build Menu t...
Tuesday, February 16, 2010

Enable Developer Tab in Office 2010

›
How to enable Developer Tab in Office 2010 If the developer tab is not showing on your Ribbon UI, you can enable it from Application Options...
2 comments:
Monday, February 15, 2010

Run Excel Macro from Powerpoint VBA

›
How to Run an Excel Macro from PowerPoint Before writing code for doing it you need to add Excel Library to the PowerPoint VBE Project Power...
7 comments:
Saturday, February 13, 2010

Office 2010 - Application.FileSearch Error

›
Application.FileSearch doesn't work in Excel 2010 (Office 2010) Application.FileSearch didn't work in Office 2007 (It has been depr...
3 comments:
Saturday, February 06, 2010

How to check compatibility issues in a Word Document

›
How to check compatibility issues in an Office Document Microsoft Office is getting polished rapidly. Upgrades from 2003 to 2010 saw sea cha...

Show All Comments using Excel VBA / Hide All Comments using Excel VBA

›
The following code is a easier way to show all comments in the Excel Spreadsheet. This comes handy when you want to view all the comments to...

Maximum Limit of Rows, Columns etc in Excel

›
How BIG is Excel 2007 and 2010 If you have worked on a large set of data from a non-Excel data source, for example, MS ACCESS, there are cha...
6 comments:
Wednesday, December 23, 2009

Word VBA – Avoid “There are too many spelling or grammatical errors in Document ...” message

›
When you are automating something in Word using VBA, the below message can be a nemesis. This message will wait for user input whereas you w...
Friday, September 25, 2009

How to export Word Range as RTF using VBA

›
Save Selected Word Range as RTF using Word VBA The following snippet saves the selected Range as RTF using VBA (Word 2007) Sub Export_Select...
Friday, August 21, 2009

How to add Format Conditions using Excel VBA

›
Conditional Formatting using Excel VBA Here is a small snippet for FormatConditions. Sub Format_Condition_Example() Dim oFc As FormatConditi...

How to Hide the PivotTable Fields List using VBA

›
Excel VBA - Hide Pivot Table Fields List If you are developing some pivot table as part of the report and feel the Pivot Fields list at the ...

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 Word docu...
4 comments:
Saturday, August 08, 2009

How to Login to Website Using VBA

›
Login to Google Account using VBA Here is a simple code that will login to Google accounts with the provided user-name and password. The pro...
15 comments:
Monday, July 27, 2009

How to change the Source of Pivot Table using VBA

›
How to configure Pivot Table source data externally through VBA A Pivot Table is linked to a particular source data. If for some reasons, yo...
4 comments:

How to Check the Source Type of Pivot Table using VBA

›
Excel VBA Check Pivot Source The following snippet could help in getting the source type of the Pivot Table Sub CheckSourceConnection() ...

How to Add Popup Menu Item in Excel/Word using VBA

›
Create Popup Menu (Right Click menu) using VBA Here is a simple snippet that will add a menu item to the popup menu and assign a macro to it...
1 comment:
Wednesday, July 22, 2009

How to Create PDF from Word Document using VBA

›
Convert Word to PDF using VBA Word 2007 has a new method - Document.ExportAsFixedFormat, which saves the document as PDF or XPS format The f...
12 comments:
Saturday, July 18, 2009

Welcome Office 2010

›
At last the Office 2010 is out - here is what Microsoft has to say about its new baby: "Microsoft® Office 2010 gives you rich and power...
1 comment:
Thursday, July 16, 2009

VBA Additional Contols not enabled in Tools menu

›
Probably a silly one, but it took some good time of one of my student. So if the 'Additional Controls' in Excel VBA/Word VBA window ...
6 comments:
Tuesday, July 14, 2009

How to Create New Menu using Excel VBA

›
How to automatically add menu to Excel using VBa Here is a code to add a new menu and a button whenever a sheet is opened. Option Explicit P...
5 comments: