Browse by Tags

  • Blog Post: How to get a list of updates

    Today of my team members asked me, how to get a list of Office and Windows updates. Surprisingly, I realized, that there is no easy way to do it (or at least I couldn’t find it ) – finally came up with following code snippets: 'For getting a list of office updates '--- --- --- --- --- --- --- ---...
  • Blog Post: Tip: Getting text from a WordArt Shape

    Here is a quick tip - Although you can't get/modify the text from a WordArt Shape using “oDocument.Shapes(n).TextFrame.TextRange.Text”, but we can modify the text using “oDocument.Shapes(n).TextEffect.Text”. Technorati tags: Tips , QuickPick , Word+2007 , Pranav+Wagh , Microsoft+Blogger del.icio.us tags...
  • Blog Post: Insert from Scanner or Camera

    Just I noticed [from a customer complain] that if you have word hosted [embedded] in any active document host, like Excel etc. and you try to do a Insert-> Image from Scanner or Camera, then word crashes. So what resolution do I have for this? not a great one ..I confess but, something is better then...
  • Blog Post: Here Is A Question!

    The title of my previous post was taken directly from on of my customers comment..to be frank even i was not very delighted when i came to know that ServerDocument.AddCustomization will automate office.. so the question to all of the VSTO/Office gurus around is ... if there is any other/better solution...
  • Blog Post: How To Load Win32 dlls Dynamically In VBA

    Well, by dynamically i just mean that i don't know the path of the dll (or the path will be decided at runtime). now the problem is; you need to add a declares statement to use a function from VB but you don't know the path so there is no way in which you can give this statement unless the dll is going...
  • Blog Post: MapPoint : Using Geofences in MapPoint Location Server Applications

    I just came across a cool article that explains how you can achieve many tasks using geofencing that seem un-doable otherwise.but what the heck is geofence ? yeah .. read on according to the article .. A geofence is a geographical region that you define and use to trigger an event when a user enters...
  • Blog Post: Excel Changes Last Modified Date

    I bet life is learning, and there is a good saying in IT "you stop earning; when you stop learning" (never heard this before..ok i admit i made it up :)). A few days i came across a problem simply i wanted to have a small tool that can archive all the XLS & DOC files which are more then 1 month old...
  • Blog Post: Which Addin Should I Use - 1

    I have seen many people asking same question. "which type of addin should i use for office".. well the answer is always same ..depends ! what is your requirement ? so i planned to have a series of posts explaining which addins should be used and where. Here are a few sample questions and offcourse their...
  • Blog Post: USING ADO AND ADO.NET WITH EXCEL: Resources and Known Issues

    General ------- Q326548 HOW TO: Use Jet OLE DB Provider 4.0 to Connect to ISAM Databases http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q326548 Q257819 HOWTO: Use ADO with Excel Data from Visual Basic or VBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q257819 Q303814 HOWTO: Use ADOX...
Page 1 of 1 (9 items)