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

Posted in Office | Tagged , | Leave a comment

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

Posted in Office, TFS | Tagged | 2 Comments

Developer Must-Have

Developer Must-Have: 125+ Apps for Office and SharePoint Code Samples.

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

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

Posted in Office | Tagged | 8 Comments

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

Posted in Office | Tagged , | Leave a comment