Category Archives: Office

Excel to XML

Posted on December 1, 2016 by ambilykk

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 →

Posted in Office | Tagged , | Leave a comment

Team Foundation Server Error: TF80012: The document cannot be opened ….

Posted on May 17, 2014 by ambilykk

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 →

Posted in Office, TFS | Tagged | 2 Comments

Developer Must-Have

Posted on May 8, 2013 by ambilykk

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

Posted in C#, Office | Tagged , | Leave a comment

Command Line Execution of Excel Macro

Posted on January 27, 2013 by ambilykk

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 →

Posted in Office | Tagged | 8 Comments

VBA – Digital Certificate Issue

Posted on October 15, 2012 by ambilykk

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 →

Posted in Office | Tagged , | Leave a comment