際際滷

際際滷Share a Scribd company logo
Office Development
      in Visual Studio 2010



Microsoft Indonesia, March 18, 2010



             Andri Yadi | a@dycode.com
          CEO, DyCode | Microsoft MVP, VSTO
       http://geeks.netindonesia.net/blogs/andriyadi
500,000,000
  users on the planet




                        * of鍖ce-watch.com
7.5%
of world population




                      * of鍖ce-watch.com
1%
                                               12%

                                                     2%




                     78%




Microsoft Of鍖ce        WordPerfect                OpenOf鍖ce                 Apple iWork



                  * http://www.webmasterpro.de/portal/news/2010/02/05/international-openof鍖ce-market-shares.html
Do you get the idea?
Huge user base
Familiarity of Office applications
Fluent UI
Easy to extend
Lets see some demo
Sales Tracking, a POC by DyCode
Microsoft Dynamics CRM
Fractal Edge Excel Integration
> Productivity Tools
Uni鍖ed solutions platform
for building Office Business
        Applications
Office 2010 Development in Visual Studio 2010
So, whats the option?
Server and Services connectivity
                                    - Line of business connectivity with BCS
                                    - Web Services & Standards-based interoperability
                                    - Integrate with hosted and on-premises SharePoint
- Evolved developer platform          solutions
   with new services and            Data-oriented development
   extensibility                    - Open XML SDK
                                    - Word, Excel, Access, Project, Visio, InfoPath
- Connected cloud and on-             Services
   premises services to a           - Built on SharePoint Platform Services
   common Office PC, phone          Improved Office Development Experience
   and browser user                 - Fluent UI & Backstage Programmability
   experience
                                    - Easier management with Visual Studio 2010 & .NET
- Developer tools for all skill-      4.0
   levels, from Access to VBA       - Application Compatibility Program
   and Visual Studio                Development tools for everyone
                                    - Simplified InfoPath design
                                    - Access applications published to Web
                                    - Access application usability/design improvements
                                    - Continued commitment to Visual Basic for
                                       Applications (VBA)
UI Extensibility
Backstage View
Its all about your document
What you can do with your
document
Programmable
Backstage - Anatomy
Backstage View ext.
Add new custom tab
Specify layout in custom tab
Hide, disable built-in tabs
RibbonX Customization
Add/remove/move/activate Tabs
Add/remove/move Groups
Create custom groups with built-in
or custom commands
High-Density Layout for custom groups
Save and load customizations from a file
RibbonX - Tab Activation
Programmatically activate a tab
IRibbonUI.ActivateTab(String TabID)

IRibbonUI.ActivateTabMso(TabAddIns)

RibbonCollection.Ribbon1.RibbonUI.Acti
vateTab("MyCustomTab")
RibbonX - Group Scaling
Built-in Ribbon groups change layout as
window resizes
In Office 2010, autoScale property can be
set on a custom group
<group id=Wheel" autoScale="true">
<customUI ...>

 <ribbon> ... </ribbon>

 <contextMenus>                         Context Menu
   <contextMenu idMso="MenuCell">       Extensibility
     <button id="ButtonRefresh .../>   Its customizable
   </contextMenu>                       New control types supported
 </contextMenus>

</customUI>
Backward compatibility (Office
       2007)
       Improved C#
       Improved deployment
!"#"
       More supports on SharePoint +
       Office 2010 integration
Deployment
          VSTOR                PIA


!"#"    Targeting to .NET Framework
       3.5 Full/Client or 4.0 Full/Client
Resources
   Office developer center:
    http://msdn.microsoft.com/office
   Office 2010 developer center:
    http://msdn.microsoft.com/en-us/office/
    ee513173.aspx
   VSTO team blog: http://blogs.msdn.com/vsto/
   How do I video: http://msdn.microsoft.com/en-us/
    vsto/dd164303.aspx
   Office UI Control ID: http://go.microsoft.com/
    fwlink/?LinkID=181052
   Open XML Developer: http://openxmldeveloper.org
Q&A
DyCode
www.dycode.com | of鍖ce@dycode.com
Dynamic IT Solutions for Optimal Business Value

More Related Content

What's hot (20)

Mai Omar Desouki - SharePoint 2013 What it means for your business
Mai Omar Desouki - SharePoint 2013 What it means for your businessMai Omar Desouki - SharePoint 2013 What it means for your business
Mai Omar Desouki - SharePoint 2013 What it means for your business
Mai Omar Desouki
Virtual Hub - Host SharePoint Framework web part as MS Teams messaging extension
Virtual Hub - Host SharePoint Framework web part as MS Teams messaging extensionVirtual Hub - Host SharePoint Framework web part as MS Teams messaging extension
Virtual Hub - Host SharePoint Framework web part as MS Teams messaging extension
Nanddeep Nachan
TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9
TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9
TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9
Nuno Godinho
What's new in Visual Studio 2022
What's new in Visual Studio 2022What's new in Visual Studio 2022
What's new in Visual Studio 2022
Muralidharan Deenathayalan
Creating No Code Solutions For Sp 2010 Ayman El Hattab
Creating No Code Solutions For Sp 2010   Ayman El HattabCreating No Code Solutions For Sp 2010   Ayman El Hattab
Creating No Code Solutions For Sp 2010 Ayman El Hattab
Ayman El-Hattab
Umbraco in 10 minutes
Umbraco in 10 minutesUmbraco in 10 minutes
Umbraco in 10 minutes
Craig Bailey
Advanced Web Technology Microsoft Silverlight
Advanced Web Technology   Microsoft SilverlightAdvanced Web Technology   Microsoft Silverlight
Advanced Web Technology Microsoft Silverlight
anandk10
Asynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.js
Asynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.jsAsynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.js
Asynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.js
Christian Heindel
Kentico CMS Overview
Kentico CMS OverviewKentico CMS Overview
Kentico CMS Overview
Craig Bailey
Intro to Bot Framework v3
Intro to Bot Framework v3Intro to Bot Framework v3
Intro to Bot Framework v3
Shahed Chowdhuri
Build Microsoft Teams Apps with Teams App Studio
Build Microsoft Teams Apps with Teams App Studio Build Microsoft Teams Apps with Teams App Studio
Build Microsoft Teams Apps with Teams App Studio
Suhail Jamaldeen
Improve customer engagement and productivity with conversational ai
Improve customer engagement and productivity with conversational aiImprove customer engagement and productivity with conversational ai
Improve customer engagement and productivity with conversational ai
CodeOps Technologies LLP
Visual Studio 2010 - O que h叩 de novo?
Visual Studio 2010 - O que h叩 de novo?Visual Studio 2010 - O que h叩 de novo?
Visual Studio 2010 - O que h叩 de novo?
Stefanini
Introducing Visual Studio LightSwitch
Introducing Visual Studio LightSwitchIntroducing Visual Studio LightSwitch
Introducing Visual Studio LightSwitch
Nuchit Atjanawat
Sharepoint mobile
Sharepoint mobileSharepoint mobile
Sharepoint mobile
Chakrapani ramachandran
Introduction to BOT Framework- Global Azure Bootcamp 2017
Introduction to BOT Framework- Global Azure Bootcamp 2017Introduction to BOT Framework- Global Azure Bootcamp 2017
Introduction to BOT Framework- Global Azure Bootcamp 2017
Jalpesh Vadgama
Build business applications with visual studio light switch
Build business applications with visual studio light switchBuild business applications with visual studio light switch
Build business applications with visual studio light switch
Nuchit Atjanawat
Building C# Applications
Building C# ApplicationsBuilding C# Applications
Building C# Applications
Vahid Farahmandian
Chatbot development with Microsoft Bot Framework and LUIS
Chatbot development with Microsoft Bot Framework and LUISChatbot development with Microsoft Bot Framework and LUIS
Chatbot development with Microsoft Bot Framework and LUIS
Md. Mahedee Hasan
ESPC Teams week Microsoft Teams & Bot Framework a Developers Perspective
ESPC Teams week Microsoft Teams & Bot Framework  a Developers PerspectiveESPC Teams week Microsoft Teams & Bot Framework  a Developers Perspective
ESPC Teams week Microsoft Teams & Bot Framework a Developers Perspective
Thomas G旦lles
Mai Omar Desouki - SharePoint 2013 What it means for your business
Mai Omar Desouki - SharePoint 2013 What it means for your businessMai Omar Desouki - SharePoint 2013 What it means for your business
Mai Omar Desouki - SharePoint 2013 What it means for your business
Mai Omar Desouki
Virtual Hub - Host SharePoint Framework web part as MS Teams messaging extension
Virtual Hub - Host SharePoint Framework web part as MS Teams messaging extensionVirtual Hub - Host SharePoint Framework web part as MS Teams messaging extension
Virtual Hub - Host SharePoint Framework web part as MS Teams messaging extension
Nanddeep Nachan
TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9
TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9
TechDays 2010 Portugal - Introduction to Silverlight 4.0 16x9
Nuno Godinho
Creating No Code Solutions For Sp 2010 Ayman El Hattab
Creating No Code Solutions For Sp 2010   Ayman El HattabCreating No Code Solutions For Sp 2010   Ayman El Hattab
Creating No Code Solutions For Sp 2010 Ayman El Hattab
Ayman El-Hattab
Umbraco in 10 minutes
Umbraco in 10 minutesUmbraco in 10 minutes
Umbraco in 10 minutes
Craig Bailey
Advanced Web Technology Microsoft Silverlight
Advanced Web Technology   Microsoft SilverlightAdvanced Web Technology   Microsoft Silverlight
Advanced Web Technology Microsoft Silverlight
anandk10
Asynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.js
Asynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.jsAsynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.js
Asynchrone Echtzeitanwendungen f端r SharePoint mit SignalR und knockout.js
Christian Heindel
Kentico CMS Overview
Kentico CMS OverviewKentico CMS Overview
Kentico CMS Overview
Craig Bailey
Intro to Bot Framework v3
Intro to Bot Framework v3Intro to Bot Framework v3
Intro to Bot Framework v3
Shahed Chowdhuri
Build Microsoft Teams Apps with Teams App Studio
Build Microsoft Teams Apps with Teams App Studio Build Microsoft Teams Apps with Teams App Studio
Build Microsoft Teams Apps with Teams App Studio
Suhail Jamaldeen
Improve customer engagement and productivity with conversational ai
Improve customer engagement and productivity with conversational aiImprove customer engagement and productivity with conversational ai
Improve customer engagement and productivity with conversational ai
CodeOps Technologies LLP
Visual Studio 2010 - O que h叩 de novo?
Visual Studio 2010 - O que h叩 de novo?Visual Studio 2010 - O que h叩 de novo?
Visual Studio 2010 - O que h叩 de novo?
Stefanini
Introducing Visual Studio LightSwitch
Introducing Visual Studio LightSwitchIntroducing Visual Studio LightSwitch
Introducing Visual Studio LightSwitch
Nuchit Atjanawat
Introduction to BOT Framework- Global Azure Bootcamp 2017
Introduction to BOT Framework- Global Azure Bootcamp 2017Introduction to BOT Framework- Global Azure Bootcamp 2017
Introduction to BOT Framework- Global Azure Bootcamp 2017
Jalpesh Vadgama
Build business applications with visual studio light switch
Build business applications with visual studio light switchBuild business applications with visual studio light switch
Build business applications with visual studio light switch
Nuchit Atjanawat
Chatbot development with Microsoft Bot Framework and LUIS
Chatbot development with Microsoft Bot Framework and LUISChatbot development with Microsoft Bot Framework and LUIS
Chatbot development with Microsoft Bot Framework and LUIS
Md. Mahedee Hasan
ESPC Teams week Microsoft Teams & Bot Framework a Developers Perspective
ESPC Teams week Microsoft Teams & Bot Framework  a Developers PerspectiveESPC Teams week Microsoft Teams & Bot Framework  a Developers Perspective
ESPC Teams week Microsoft Teams & Bot Framework a Developers Perspective
Thomas G旦lles

Similar to Office 2010 Development in Visual Studio 2010 (20)

Office As A Development Platform
Office As A Development PlatformOffice As A Development Platform
Office As A Development Platform
Christof Sprenger
Overview visual studio
Overview visual studioOverview visual studio
Overview visual studio
Luis Daniel Abelaira Huertos
The Notes/Domino Application Development Competitive Advantage - IamLUG
The Notes/Domino Application Development Competitive Advantage - IamLUGThe Notes/Domino Application Development Competitive Advantage - IamLUG
The Notes/Domino Application Development Competitive Advantage - IamLUG
John Head
Irw Generic Power Point
Irw Generic Power PointIrw Generic Power Point
Irw Generic Power Point
NatashaIRWS
Overview
OverviewOverview
Overview
ALOK RAJ
Office And Vsto 200
Office And Vsto 200Office And Vsto 200
Office And Vsto 200
Mithun T. Dhar
Service Pack One for InduSoft Web Studio 8.0
Service Pack One for InduSoft Web Studio 8.0Service Pack One for InduSoft Web Studio 8.0
Service Pack One for InduSoft Web Studio 8.0
AVEVA
MWLUG 2011: Notes/Domino Application Development Competitive Advantage
MWLUG 2011: Notes/Domino Application Development Competitive AdvantageMWLUG 2011: Notes/Domino Application Development Competitive Advantage
MWLUG 2011: Notes/Domino Application Development Competitive Advantage
John Head
Session 2: Office as a development platform with Visual Studio 2008
Session 2: Office as a development platform with Visual Studio 2008Session 2: Office as a development platform with Visual Studio 2008
Session 2: Office as a development platform with Visual Studio 2008
ukdpe
Vs 2008
Vs 2008Vs 2008
Vs 2008
ankurbatla
.net 3.5 and vs 2008
.net 3.5 and vs 2008.net 3.5 and vs 2008
.net 3.5 and vs 2008
maddinapudi
Seminar On Share Point By Maroof Ahmad
Seminar On Share Point By Maroof AhmadSeminar On Share Point By Maroof Ahmad
Seminar On Share Point By Maroof Ahmad
MaroofAhmad
George Jordanov CV
George Jordanov CVGeorge Jordanov CV
George Jordanov CV
George Jordanov
G saadeh resume
G saadeh resumeG saadeh resume
G saadeh resume
gsaadeh
G saadeh resume
G saadeh resumeG saadeh resume
G saadeh resume
gsaadeh
Developing for Office 2007 using VSTO 2005
Developing for Office 2007 using VSTO 2005Developing for Office 2007 using VSTO 2005
Developing for Office 2007 using VSTO 2005
sudhakar
Resume ankur new
Resume ankur newResume ankur new
Resume ankur new
Ankur bhardwaj
Office Add-ins developer community call-January 2020
Office Add-ins developer community call-January 2020Office Add-ins developer community call-January 2020
Office Add-ins developer community call-January 2020
Microsoft 365 Developer
Office apps in Office 365 - Napa the next big thing
Office apps in Office 365 - Napa the next big thingOffice apps in Office 365 - Napa the next big thing
Office apps in Office 365 - Napa the next big thing
SPC Adriatics
Practical Office Business Application
Practical Office Business ApplicationPractical Office Business Application
Practical Office Business Application
Andri Yadi
Office As A Development Platform
Office As A Development PlatformOffice As A Development Platform
Office As A Development Platform
Christof Sprenger
The Notes/Domino Application Development Competitive Advantage - IamLUG
The Notes/Domino Application Development Competitive Advantage - IamLUGThe Notes/Domino Application Development Competitive Advantage - IamLUG
The Notes/Domino Application Development Competitive Advantage - IamLUG
John Head
Irw Generic Power Point
Irw Generic Power PointIrw Generic Power Point
Irw Generic Power Point
NatashaIRWS
Overview
OverviewOverview
Overview
ALOK RAJ
Office And Vsto 200
Office And Vsto 200Office And Vsto 200
Office And Vsto 200
Mithun T. Dhar
Service Pack One for InduSoft Web Studio 8.0
Service Pack One for InduSoft Web Studio 8.0Service Pack One for InduSoft Web Studio 8.0
Service Pack One for InduSoft Web Studio 8.0
AVEVA
MWLUG 2011: Notes/Domino Application Development Competitive Advantage
MWLUG 2011: Notes/Domino Application Development Competitive AdvantageMWLUG 2011: Notes/Domino Application Development Competitive Advantage
MWLUG 2011: Notes/Domino Application Development Competitive Advantage
John Head
Session 2: Office as a development platform with Visual Studio 2008
Session 2: Office as a development platform with Visual Studio 2008Session 2: Office as a development platform with Visual Studio 2008
Session 2: Office as a development platform with Visual Studio 2008
ukdpe
.net 3.5 and vs 2008
.net 3.5 and vs 2008.net 3.5 and vs 2008
.net 3.5 and vs 2008
maddinapudi
Seminar On Share Point By Maroof Ahmad
Seminar On Share Point By Maroof AhmadSeminar On Share Point By Maroof Ahmad
Seminar On Share Point By Maroof Ahmad
MaroofAhmad
G saadeh resume
G saadeh resumeG saadeh resume
G saadeh resume
gsaadeh
G saadeh resume
G saadeh resumeG saadeh resume
G saadeh resume
gsaadeh
Developing for Office 2007 using VSTO 2005
Developing for Office 2007 using VSTO 2005Developing for Office 2007 using VSTO 2005
Developing for Office 2007 using VSTO 2005
sudhakar
Office Add-ins developer community call-January 2020
Office Add-ins developer community call-January 2020Office Add-ins developer community call-January 2020
Office Add-ins developer community call-January 2020
Microsoft 365 Developer
Office apps in Office 365 - Napa the next big thing
Office apps in Office 365 - Napa the next big thingOffice apps in Office 365 - Napa the next big thing
Office apps in Office 365 - Napa the next big thing
SPC Adriatics
Practical Office Business Application
Practical Office Business ApplicationPractical Office Business Application
Practical Office Business Application
Andri Yadi

More from Andri Yadi (20)

AIoT: Intelligence on Microcontroller
AIoT: Intelligence on MicrocontrollerAIoT: Intelligence on Microcontroller
AIoT: Intelligence on Microcontroller
Andri Yadi
TechInAsia PDC 2019 - Unlocking The Potential of IoT with AI
TechInAsia PDC 2019 - Unlocking The Potential of IoT with AITechInAsia PDC 2019 - Unlocking The Potential of IoT with AI
TechInAsia PDC 2019 - Unlocking The Potential of IoT with AI
Andri Yadi
Global Azure Bootcamp 2019 - AIoT powered by Azure
Global Azure Bootcamp 2019 - AIoT powered by AzureGlobal Azure Bootcamp 2019 - AIoT powered by Azure
Global Azure Bootcamp 2019 - AIoT powered by Azure
Andri Yadi
Introduction to AIoT & TinyML - with Arduino
Introduction to AIoT & TinyML - with ArduinoIntroduction to AIoT & TinyML - with Arduino
Introduction to AIoT & TinyML - with Arduino
Andri Yadi
Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...
Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...
Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...
Andri Yadi
Microsoft Azure-powered IoT & AI Solution To Help Farmer
Microsoft Azure-powered IoT & AI Solution To Help FarmerMicrosoft Azure-powered IoT & AI Solution To Help Farmer
Microsoft Azure-powered IoT & AI Solution To Help Farmer
Andri Yadi
IoT Connectivity with LoRa
IoT Connectivity with LoRaIoT Connectivity with LoRa
IoT Connectivity with LoRa
Andri Yadi
Ask the Expert: Internet of Things
Ask the Expert: Internet of ThingsAsk the Expert: Internet of Things
Ask the Expert: Internet of Things
Andri Yadi
Global Azure Bootcamp 2018 - Azure IoT Central
Global Azure Bootcamp 2018 - Azure IoT CentralGlobal Azure Bootcamp 2018 - Azure IoT Central
Global Azure Bootcamp 2018 - Azure IoT Central
Andri Yadi
Maker Movement toward IoT Ecosystem in Indonesia
Maker Movement toward IoT Ecosystem in IndonesiaMaker Movement toward IoT Ecosystem in Indonesia
Maker Movement toward IoT Ecosystem in Indonesia
Andri Yadi
IoT for Agriculture in a Nutshell: Technical Perspective
IoT for Agriculture in a Nutshell: Technical PerspectiveIoT for Agriculture in a Nutshell: Technical Perspective
IoT for Agriculture in a Nutshell: Technical Perspective
Andri Yadi
Road to Republic of IoT - IoT Technologies & Machine Learning
Road to Republic of IoT - IoT Technologies & Machine LearningRoad to Republic of IoT - IoT Technologies & Machine Learning
Road to Republic of IoT - IoT Technologies & Machine Learning
Andri Yadi
IoT Connectivity: The Technical & Potential
IoT Connectivity: The Technical & PotentialIoT Connectivity: The Technical & Potential
IoT Connectivity: The Technical & Potential
Andri Yadi
IT Solution through IoT Development
IT Solution through IoT DevelopmentIT Solution through IoT Development
IT Solution through IoT Development
Andri Yadi
Internet of Things - Technicals
Internet of Things - TechnicalsInternet of Things - Technicals
Internet of Things - Technicals
Andri Yadi
Global Azure Bootcamp 2017 - Azure IoT Hub with LoRa Connectivity
Global Azure Bootcamp 2017 - Azure IoT Hub with LoRa ConnectivityGlobal Azure Bootcamp 2017 - Azure IoT Hub with LoRa Connectivity
Global Azure Bootcamp 2017 - Azure IoT Hub with LoRa Connectivity
Andri Yadi
The state of NB-IoT in Indonesia
The state of NB-IoT in IndonesiaThe state of NB-IoT in Indonesia
The state of NB-IoT in Indonesia
Andri Yadi
Industrial IoT in a Nutshell
Industrial IoT in a NutshellIndustrial IoT in a Nutshell
Industrial IoT in a Nutshell
Andri Yadi
The Rise of Maker Movement in Indonesia
The Rise of Maker Movement in IndonesiaThe Rise of Maker Movement in Indonesia
The Rise of Maker Movement in Indonesia
Andri Yadi
Road to Republic of IoT - ESP32 Programming and LoRa
Road to Republic of IoT - ESP32 Programming and LoRaRoad to Republic of IoT - ESP32 Programming and LoRa
Road to Republic of IoT - ESP32 Programming and LoRa
Andri Yadi
AIoT: Intelligence on Microcontroller
AIoT: Intelligence on MicrocontrollerAIoT: Intelligence on Microcontroller
AIoT: Intelligence on Microcontroller
Andri Yadi
TechInAsia PDC 2019 - Unlocking The Potential of IoT with AI
TechInAsia PDC 2019 - Unlocking The Potential of IoT with AITechInAsia PDC 2019 - Unlocking The Potential of IoT with AI
TechInAsia PDC 2019 - Unlocking The Potential of IoT with AI
Andri Yadi
Global Azure Bootcamp 2019 - AIoT powered by Azure
Global Azure Bootcamp 2019 - AIoT powered by AzureGlobal Azure Bootcamp 2019 - AIoT powered by Azure
Global Azure Bootcamp 2019 - AIoT powered by Azure
Andri Yadi
Introduction to AIoT & TinyML - with Arduino
Introduction to AIoT & TinyML - with ArduinoIntroduction to AIoT & TinyML - with Arduino
Introduction to AIoT & TinyML - with Arduino
Andri Yadi
Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...
Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...
Opportunities & Challenges in IoT - Future of IoT industry in Indonesia 2019 ...
Andri Yadi
Microsoft Azure-powered IoT & AI Solution To Help Farmer
Microsoft Azure-powered IoT & AI Solution To Help FarmerMicrosoft Azure-powered IoT & AI Solution To Help Farmer
Microsoft Azure-powered IoT & AI Solution To Help Farmer
Andri Yadi
IoT Connectivity with LoRa
IoT Connectivity with LoRaIoT Connectivity with LoRa
IoT Connectivity with LoRa
Andri Yadi
Ask the Expert: Internet of Things
Ask the Expert: Internet of ThingsAsk the Expert: Internet of Things
Ask the Expert: Internet of Things
Andri Yadi
Global Azure Bootcamp 2018 - Azure IoT Central
Global Azure Bootcamp 2018 - Azure IoT CentralGlobal Azure Bootcamp 2018 - Azure IoT Central
Global Azure Bootcamp 2018 - Azure IoT Central
Andri Yadi
Maker Movement toward IoT Ecosystem in Indonesia
Maker Movement toward IoT Ecosystem in IndonesiaMaker Movement toward IoT Ecosystem in Indonesia
Maker Movement toward IoT Ecosystem in Indonesia
Andri Yadi
IoT for Agriculture in a Nutshell: Technical Perspective
IoT for Agriculture in a Nutshell: Technical PerspectiveIoT for Agriculture in a Nutshell: Technical Perspective
IoT for Agriculture in a Nutshell: Technical Perspective
Andri Yadi
Road to Republic of IoT - IoT Technologies & Machine Learning
Road to Republic of IoT - IoT Technologies & Machine LearningRoad to Republic of IoT - IoT Technologies & Machine Learning
Road to Republic of IoT - IoT Technologies & Machine Learning
Andri Yadi
IoT Connectivity: The Technical & Potential
IoT Connectivity: The Technical & PotentialIoT Connectivity: The Technical & Potential
IoT Connectivity: The Technical & Potential
Andri Yadi
IT Solution through IoT Development
IT Solution through IoT DevelopmentIT Solution through IoT Development
IT Solution through IoT Development
Andri Yadi
Internet of Things - Technicals
Internet of Things - TechnicalsInternet of Things - Technicals
Internet of Things - Technicals
Andri Yadi
Global Azure Bootcamp 2017 - Azure IoT Hub with LoRa Connectivity
Global Azure Bootcamp 2017 - Azure IoT Hub with LoRa ConnectivityGlobal Azure Bootcamp 2017 - Azure IoT Hub with LoRa Connectivity
Global Azure Bootcamp 2017 - Azure IoT Hub with LoRa Connectivity
Andri Yadi
The state of NB-IoT in Indonesia
The state of NB-IoT in IndonesiaThe state of NB-IoT in Indonesia
The state of NB-IoT in Indonesia
Andri Yadi
Industrial IoT in a Nutshell
Industrial IoT in a NutshellIndustrial IoT in a Nutshell
Industrial IoT in a Nutshell
Andri Yadi
The Rise of Maker Movement in Indonesia
The Rise of Maker Movement in IndonesiaThe Rise of Maker Movement in Indonesia
The Rise of Maker Movement in Indonesia
Andri Yadi
Road to Republic of IoT - ESP32 Programming and LoRa
Road to Republic of IoT - ESP32 Programming and LoRaRoad to Republic of IoT - ESP32 Programming and LoRa
Road to Republic of IoT - ESP32 Programming and LoRa
Andri Yadi

Office 2010 Development in Visual Studio 2010

  • 1. Office Development in Visual Studio 2010 Microsoft Indonesia, March 18, 2010 Andri Yadi | a@dycode.com CEO, DyCode | Microsoft MVP, VSTO http://geeks.netindonesia.net/blogs/andriyadi
  • 2. 500,000,000 users on the planet * of鍖ce-watch.com
  • 3. 7.5% of world population * of鍖ce-watch.com
  • 4. 1% 12% 2% 78% Microsoft Of鍖ce WordPerfect OpenOf鍖ce Apple iWork * http://www.webmasterpro.de/portal/news/2010/02/05/international-openof鍖ce-market-shares.html
  • 5. Do you get the idea?
  • 6. Huge user base Familiarity of Office applications Fluent UI Easy to extend
  • 8. Sales Tracking, a POC by DyCode
  • 10. Fractal Edge Excel Integration
  • 12. Uni鍖ed solutions platform for building Office Business Applications
  • 14. So, whats the option?
  • 15. Server and Services connectivity - Line of business connectivity with BCS - Web Services & Standards-based interoperability - Integrate with hosted and on-premises SharePoint - Evolved developer platform solutions with new services and Data-oriented development extensibility - Open XML SDK - Word, Excel, Access, Project, Visio, InfoPath - Connected cloud and on- Services premises services to a - Built on SharePoint Platform Services common Office PC, phone Improved Office Development Experience and browser user - Fluent UI & Backstage Programmability experience - Easier management with Visual Studio 2010 & .NET - Developer tools for all skill- 4.0 levels, from Access to VBA - Application Compatibility Program and Visual Studio Development tools for everyone - Simplified InfoPath design - Access applications published to Web - Access application usability/design improvements - Continued commitment to Visual Basic for Applications (VBA)
  • 17. Backstage View Its all about your document What you can do with your document Programmable
  • 19. Backstage View ext. Add new custom tab Specify layout in custom tab Hide, disable built-in tabs
  • 20. RibbonX Customization Add/remove/move/activate Tabs Add/remove/move Groups Create custom groups with built-in or custom commands High-Density Layout for custom groups Save and load customizations from a file
  • 21. RibbonX - Tab Activation Programmatically activate a tab IRibbonUI.ActivateTab(String TabID) IRibbonUI.ActivateTabMso(TabAddIns) RibbonCollection.Ribbon1.RibbonUI.Acti vateTab("MyCustomTab")
  • 22. RibbonX - Group Scaling Built-in Ribbon groups change layout as window resizes In Office 2010, autoScale property can be set on a custom group <group id=Wheel" autoScale="true">
  • 23. <customUI ...> <ribbon> ... </ribbon> <contextMenus> Context Menu <contextMenu idMso="MenuCell"> Extensibility <button id="ButtonRefresh .../> Its customizable </contextMenu> New control types supported </contextMenus> </customUI>
  • 24. Backward compatibility (Office 2007) Improved C# Improved deployment !"#" More supports on SharePoint + Office 2010 integration
  • 25. Deployment VSTOR PIA !"#" Targeting to .NET Framework 3.5 Full/Client or 4.0 Full/Client
  • 26. Resources Office developer center: http://msdn.microsoft.com/office Office 2010 developer center: http://msdn.microsoft.com/en-us/office/ ee513173.aspx VSTO team blog: http://blogs.msdn.com/vsto/ How do I video: http://msdn.microsoft.com/en-us/ vsto/dd164303.aspx Office UI Control ID: http://go.microsoft.com/ fwlink/?LinkID=181052 Open XML Developer: http://openxmldeveloper.org
  • 27. Q&A
  • 28. DyCode www.dycode.com | of鍖ce@dycode.com Dynamic IT Solutions for Optimal Business Value