Office 11 gains developer tools

Daily Newsletters

Sign up to ZDNet UK's daily newsletter.

NEWS
Microsoft unveiled on Monday a tool for customising Office 11 applications based on its Visual Studio programming environment. The new tool, code-named Visual Studio Tools for Office, exploits the data-sharing capabilities of XML (Extended Markup Language) to help developers create Office-based applications. The enhancements are designed to let companies tailor Microsoft Word and Excel applications to their specific corporate processes and to link "islands of data," said Robert Green, lead product manager for Visual Studio at Microsoft. "Business processes are not well-integrated, particularly when they include data at the desktop. We're going to see much better interconnections," Green said. The tool will work with the Office 11 versions of Word and Excel, which are supposed to become available by the middle of next year. With Office being tied to Visual Studio, people who work with Microsoft languages Visual Basic and C# stand to benefit from an environment aimed specifically at professional developers. Programmers can also take advantage of the .Net Framework in Visual Studio.Net, which automatically generates much of the lower-level coding needed for networked applications. Microsoft rival Sun Microsystems plans similar developments for its StarOffice suite of applications. By the middle of next year, Sun plans to release a version of StarOffice that will let professional Java programmers customise StarOffice applications. Microsoft Office developers use Visual Basic for Applications (VBA), which is employed by both professional developers and so-called power users, or businesspeople able to write scripts, or macros, to modify Office applications. When Office 11 comes out, Microsoft will enhance VBA with the ability to integrate Web services into Office applications, but will steer professional developers toward the Visual Studio for Office. Visual Studio Tools for Office will exploit the increased support for XML within Office 11 documents. When the tool is released next year, customers will be able to set their own XML schema definitions, or document structures. Company- and industry-specific document definitions will give developers finer control of data within Word and Excel. For example, an application could automatically link information from a specific cell in an Excel spreadsheet to another application. The new development environment will also introduce a "smart document application model," a series of tools for providing in-context information to Word and Excel documents. This feature will let developers, for example, manipulate the Task Pane in Excel to give people help tailored to the application or access to relevant back-end data, Microsoft executives explained. Visual Studio Tools for Office will benefit IT administrators as well, Microsoft executives said. For maintenance and security and reasons, businesses can keep the code that provides the custom functions on network servers and restrict access to unknown Web sites.
ZDNet UK's Developer News Section delivers the latest headlines together with the best UK jobs, right to your browser. Have your say on all developer topics. From j2ee, to C++, from Visual Basic to Javascript plus much more. Share your experience with others on the Developers Forum. Let the editors know what you think in the Mailroom.

Post your comment

In order to post a comment you need to be registered and logged in.

You can also log in with Facebook. Log in or create your ZDNet UK account below

  • Login

Will not be displayed with your comment

By signing up for this service, you indicate that you agree to our Terms and Conditions and have read and understood our Privacy Policy. Questions about membership? Find the answers in the Community FAQ

Get ZDNet UK's daily newsletter

Enter your email address to sign up

ZDNet UK Live

GHar123

I totally dislike pirating of works, I fear that artists will be deterred from creating works if they think that they are going to get ripped off....

6 minutes ago by GHar123 on ACTA stumbles in Germany
JCB33

How dare film makers, artists or anybody that invests in creativity stop us pirating their works for free. I want to be able to walk into my local...

6 hours ago by JCB33 on ACTA stumbles in Germany
Moley

@GrueMaster. I prefer horses for courses rather than one size fits all. I, and I suspect most other computer users, do not really wish to have...

8 hours ago by Moley on A tale of two distros: Ubuntu and Linux Mint
greycynic

The product that scares me every time I have to use it is the Office 2007 version of Excel. The first bug that I found was applying the median...

8 hours ago by greycynic on Ten flawed products that derail productivity
GrueMaster

Nice review and very informative. One thing I'd like to add (in reply to whs001's 1st question), the main reason to have the same interface from...

9 hours ago by GrueMaster on A tale of two distros: Ubuntu and Linux Mint
Frederick Wrigley

I'be been using Mint 12 since the RC came out, and I am far more happy with the Cinnamon, the Mate, and, yes (with extensions), theGnome 3...

10 hours ago by Frederick Wrigley via Facebook on A tale of two distros: Ubuntu and Linux Mint
bdantas

Excellent article. One small correction, though--although a fresh installation of Linux Mint 12 will, indeed, provide the user with a version of...

11 hours ago by bdantas on A tale of two distros: Ubuntu and Linux Mint
Alan Ralph

In related news, the ISPs club together to get the members of the Home Affairs Select Committee (ya goofed on that part, ZDNet UK) copies of "The...

11 hours ago by Alan Ralph via Facebook on MPs urge ISPs to take down terrorist material
Alan Ralph

In related news, the ISPs club together to get the members of the Home Affairs Select Committee (ya goofed on that part, ZDNet UK) copies of "The...

11 hours ago by Alan Ralph via Facebook on MPs urge ISPs to take down terrorist material
Moley

For Gnome 2 die-hards, it is possible to add icons to the bottom panel (or top top panel, if you prefer) which provide the exact Gnome 2...

12 hours ago by Moley on A tale of two distros: Ubuntu and Linux Mint
ramwellian

Your comments would seem pretty naive and immature. Your 'solution' appears to be, "gee, let's all just give in to the hackers and give them...

12 hours ago by ramwellian on Cloud computing security: no more oxymoron?
BugStalker

"Interesting thought ... If you installed Win7 as a dual boot on a machine that previously only had Linux, and it wrecked your Linux installation,...

13 hours ago by BugStalker on Windows 7 Declares War on GRUB
whs001

This is an excellent summary of Ubuntu and Mint and the interface differences between them. Most such articles take a very partisan position for...

13 hours ago by whs001 on A tale of two distros: Ubuntu and Linux Mint
Moley

@ewallace. Not so clear. Anyone can obtain the text, for example from here http://www.ustr.gov/webfm_send/2379. I support ACTA so long as it and...

13 hours ago by Moley on ACTA: Facts, misconceptions and questions
45283

I think WinRT is fantastic. I just wish it was an option for people that didn't want to go through Microsoft's App Store with its attendant...

16 hours ago by 45283 on Why Windows 8 needs architectural hygiene for WOA
Burn-IT

Nine people? £30m? Who's back pocket is that lot going in? And IF they say it is for new buildings, what about all the ones the government has...

17 hours ago by Burn-IT on Police set to launch three £30m e-crime hubs
ewallace

Just to be clear, nobody knows what is in the text of ACTA, here is a photograph of the text of ACTA http://twitpic.com/8h9iju as submitted to the...

17 hours ago by ewallace on ACTA: Facts, misconceptions and questions
fgvrg56

Unfortunately main issue is that ASUS is refusing to accept that they make some mistake on this version of asus Transformer prime. 1 - GPS sensor...

19 hours ago by fgvrg56 on Asus Eee Pad Transformer Prime Wi-Fi & GPS problems?
Ben Woods

@Marcus A fair question. Just talked with Archos which said it was working on an announcement for next week....

20 hours ago by Ben Woods on Archos confirms G9 Ice Cream Sandwich update schedule
Marcus Karlsson

Any update on this, considering the claimed "first week of February"?

21 hours ago by Marcus Karlsson via Facebook on Archos confirms G9 Ice Cream Sandwich update schedule

Latest in Application Development