TechTalk

Recently i had to call .NET code from my VBA Macro in order to do something not available out of the box using VBA. i searched a lot of content on the web and found this wonderful web page http://www.geeksengine.com/article/create-dll.html The article clearly explains how to create a dll and reference it in VBA. There were a some issues I hit upon while following the instructions mentioned in the link 1. In my code I had the following line of code     Set f1 = New myplugin.Class1 The VBA compiler complained invalid use of New Keyword. I then modified my code to the following based on a colleague's suggestion Set f1 = CreateObject("myplugin.Class1") and then it worked fine. 2. On trying to create an instance of the .NET class in my VBA code When distributing the dll by using following link, I hit upon an issue http://www.geeksengine.com/article/register-dll.html I was getting the following error on target machines RegAsm: error RA0000 : Unable to locate

Asynchronous Javascript (AJAX) technology enables web applications to provide features like- Partial Page Updates - Allows you to define an area of a webpage to postback and update independently from the rest of the page. Only the updated content is refreshed when the request completes Indicate Progress of an operation - This allows you to track progress of server-side process and continuously update the user. Desktop-like UI - With AJAX, you can provide users with controls such as modal dialog boxes, progress indicators, masked edit bixes, tooltips and more. Cross Browser, cross platform support - Javascript, AJAX and JQuery are all supported on multiple browsers and multiple platforms. Every ASP.NET page that uses AJAX must have one and only one ScriptManager class which enables- Registration of custom scripts Registration of web service method calls from client Since you can use only one instance of ScriptManager class in an ASP.NET page there is a need to use ScriptMan

This blog post is an extract of VSTO for Dummies. VSTO isn' t a replacement technology for Visual Basic for Applications (VBA). VSTO is a set of tools that you can use with Visual Studio to supercharge Office. Put simply, VSTO offers tools to - 1. Build add-ins 2. Build customised documents for Office Applications like Word and Excel. Add your custom functionality to existing Office applications, via add-ins. Leverage all the existing Office functionality in your applications, like Word document layout and Excel formulas, through communicating with those add-ins Make documents that integrate fully with existing applications and databases Use Microsoft SharePoint to increase communications between knowledge workers with add-ins and documents that communicate. At their core, Customized Documents are document-level only, while add-ins are application-level and can apply to all documents used by that installation of Office. Four important features are availabl