Books
-
Recent Posts
Archives
Categories
- .NET Core (1)
- ActivityDesigner (5)
- AngularJs (7)
- Architecture Features (1)
- ASP.Net (24)
- Entity Framework (3)
- ASP.Net 4.5 (6)
- Azure (16)
- Book (6)
- C# (22)
- C# 4.0 (4)
- Cognitive Services (1)
- Contest (5)
- DevOps (1)
- EnvDTE (3)
- feature Builder (1)
- General (8)
- Google (3)
- HTML5 (20)
- IDE (3)
- IE (3)
- IIS (1)
- jQuery (3)
- LightSwitch (1)
- LINQ (2)
- Load Test (5)
- Lync Server 2010 (2)
- Microsoft (21)
- MVC (7)
- Node (2)
- Office (5)
- Open XML (1)
- performance Test (6)
- Pex and Moles (3)
- Site Review (2)
- SQL (6)
- TFS (18)
- Tools (6)
- UI (1)
- Uncategorized (26)
- Visual Studio (18)
- Visual Studio 2015 (12)
- Visual Studio 2010 (15)
- WCF (1)
- Visual Studio 2011 (4)
- Metro App (1)
- Visual Studio 2012 (14)
- Visual Studio 2013 (5)
- VSTS 2010 (12)
- LightSwitch (1)
- VSTS 2011 (3)
- WebMatrix (2)
- WF (9)
- WF4 (20)
- Windows (11)
- Windows 8 App (8)
- Windows Phone 7 (1)
- WPF (9)
Meta
Blog Stats
- 156,609 hits
Category Archives: Office
Excel to XML
Looks Simple ! Yes, even I thought the same. Obviously, excel provides an option to save the data in XML format. Did you tried any time the same ? If so, you may be faced the real challenge in converting … Continue reading
Team Foundation Server Error: TF80012: The document cannot be opened ….
Issue We are using Team Foundation Server(TFS) for managing test cases and bugs. We want to export the query result from TFS to an excel file for offline update. When we try to open the query result in excel, we … Continue reading
Developer Must-Have
Developer Must-Have: 125+ Apps for Office and SharePoint Code Samples. http://blogs.msdn.com/b/officeapps/archive/2013/04/18/developer-must-have-125-apps-for-office-and-sharepoint-code-samples.aspx
Command Line Execution of Excel Macro
Recently we have got a requirement for executing a macro from command line. We have achieved the objective using following code snippet. Step 1: Command line extractor module Open the excel workbook and navigate to the Visual Basic editor. Add … Continue reading
VBA – Digital Certificate Issue
When we work on a Macro enabled excel file with digital certificate, most of us faced the issue – “There was a problem with the digital certificate. The VBA project could not be signed. The signature will be discarded”. Today … Continue reading