Cyberiafreak

"Fortunate are those who take the first steps.” ― Paulo Coelho

From training-links for later reading { O365 apps, Office PIA, XL, VSTO }

O365 web apps development
1) The Office 365 platform —new opportunities for developers
http://blogs.office.com/2014/03/03/create-apps-for-office-365/

2) Here is a Video of the possibilities :
http://www.youtube.com/watch?v=qryRH5xXyJk&feature=player_embedded

3) MSDN article we might need to be aware of -Office 365 APIs Preview
http://msdn.microsoft.com/en-us/library/office/dn605892.aspx

4) How to: Add Office 365 APIs to a Visual Studio project
http://msdn.microsoft.com/en-us/library/office/dn605899.aspx

UDF
5) What is UDF – http://blogs.msdn.com/b/frice/archive/2004/06/11/153891.aspx

6) UDF using .NET – http://blogs.msdn.com/b/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx

7) http://msdn.microsoft.com/en-us/library/ms173189(v=vs.80).aspx

8) Automation Add-ins section – http://support.microsoft.com/kb/291392

XLL
9) What is XLL – An XLL is an add-in for Microsoft Excel that you can build with any compiler that supports building DLLs (dynamic link libraries).
10) Download XLL SDK from – http://go.microsoft.com/fwlink/?LinkID=251082&clcid=0x409

11) http://blogs.msdn.com/b/andreww/archive/2007/12/09/building-an-excel-xll-in-c-c-with-vs-2008.aspx

12) http://msdn.microsoft.com/en-us/library/office/bb687861(v=office.15).aspx

13) http://support.microsoft.com/kb/178474

 

Excel
14) Understanding the Excel Object Model from a .NET Developer’s Perspective
http://msdn.microsoft.com/en-us/library/office/aa168292(v=office.11).aspx

15) How to automate Microsoft Excel from Microsoft Visual C#.NET
http://support.microsoft.com/kb/302084

16) How to transfer data to an Excel workbook by using Visual Basic .NET
http://support.microsoft.com/kb/306022

17) How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays
http://support.microsoft.com/kb/302094

 

Office PIA
18) http://msdn.microsoft.com/en-us/library/15s06t57(v=vs.110).aspx

19) Primary Interop Assemblies Concept – http://msdn.microsoft.com/en-us/library/aax7sdch.aspx

20) http://msdn.microsoft.com/en-us/library/aa302338.aspx

21) Better eventing support in CLR 4.0 using NOPIA support
http://blogs.msdn.com/b/mshneer/archive/2008/10/28/better-eventing-support-in-clr-4-0-using-nopia-support.aspx

22) How to: Install Office Primary Interop Assemblies – http://msdn.microsoft.com/en-us/library/kh3965hw(v=VS.90).aspx

 

VSTO

23) Adding custom task pane
http://social.msdn.microsoft.com/Forums/vstudio/en-US/3316853c-4cec-4cf5-8cf7-5fe6f3cd1bfe/adding-custom-task-pane?forum=vsto

24) How to: Attach Managed Code Extensions to Documents (2007 System)
http://msdn.microsoft.com/en-us/library/bb772091(v=vs.90).aspx

25) Memory leak (When you automate a Off app from .NET, the Office application does not quit when you call the Quit method)
http://support.microsoft.com/kb/317109

Advertisements

April 18, 2014 - Posted by | Uncategorized |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: