Just published some articles, it’s actually a collection of kb articles and i really appreciate kayodeok for his efforts; from whose site I got this fabulous collection.
Have a look at http://blogs.msdn.com/pranavwagh/archive/category/12235.aspx
I am also planning to include a Table Of Contents in my blog, what do you people think about it
Cool Vids from IE Team..., Download and see according to your download speed ;) offcourse thanks to sean alexander
IE7_Big.wmv (7.8MB)IE7_Medium.wmv (2.9MB)IE7_Small.wmv (1MB)
Now its not about *pure* office automation ! big question for all of you ...don't see my comment on the blog :) in has the answer. here it goes..i have a system to open any document that is selected in the drop-down list using my program(coded in C#) i use Process object to open the docs so that i can log when the document was opened and when it was closed, when i use a word document and say
x =
x.EnableRaisingEvents = True
x.Start(
after the "Start" x becomes null (nothing), strange ..! then i tried
x.StartInfo.FileName =
x.StartInfo.Arguments =
x.Start()
this works but still there is a problem, if a document is opened previously then again the i am at the square 1.
Any answers...now what to do ..??? try your dev skills ...!
Yes, Sometimes i do project automation and believe me its not as easy as it is in Word or Excel the basic problem here is there is no add-in concept so i had to create an application that adds the command bars and then hooks the events every thing seems working but unfortuantely it doesn't work...!! the error i get (generally..) is "Call reject by callee", i know this error is generally thrown when app is busy, but its busy in what..??? i just hooked one event..! Finally i thought i need the help of some project gurus so posted my query to larry's blog on http://blogs.msdn.com/lduff if he doesn't have a way, then god help me ..!!
I just checked with my VSTO team contact andrew http://blogs.msdn.com/andreww/default.aspx and i got the info in his own words
"This is not supported in VSTO 2005.We're looking at what is the best way forward for this feature request in VSTO 'v3'."
and i am sure you people know why to believe on his words..!!
No, We don't ..!! its once again proved by maarten have a look at this blog where he tells you how to remove convert the Clasic Worksheet to Extended Worksheet, http://blogs.officezealot.com/maarten/archive/2005/06/08/4673.aspx and whats more if you have any confussion on how to convert it to VB .NET maarten comes back again to hold your hand http://blogs.officezealot.com/maarten/archive/2005/09/12/7979.aspx, i guess i have a question for VSTO devs, if this was possible why we don't have an easier way to do it, and the the more important point here is the code we are using here looks scary, like for example Me.VBProject.VBComponents.Item(1) is a pure workaround just to refresh the VBProjects associated with the workbook or when your try to search for help on New Microsoft.Office.Tools.Excel.Worksheet(hostprovider, RuntimeCallback, workSheet.CodeName, Microsoft.VisualBasic.Constants.vbNull, workSheet.Name) search Tools.Excel.Worksheet in MSDN and you will know that "Worksheet host items cannot be created programmatically. For more information, see Worksheet and Host Items and Host Controls Overview." but it still works...!! anyway i am happy maybe its a big question for VSTO guys