Microsoft Announces New Office Tools

By Nate Mook | Published December 10, 2002, 4:40 AM

Microsoft announced on Monday an upcoming set of developer tools, code-named "Visual Studio Tools for Office," which enable the creation of applications that run in Microsoft Word and Excel. Developers will be able to write code in Visual Basic .NET and Visual C# that executes behind documents and takes advantage of Office 11's XML support.

"Microsoft is focused on creating great opportunities for developers, and 'Visual Studio Tools for Office' enables developers to build solutions that provide an intuitive end-user experience," said Microsoft's vice president of the Developer Platform and Evangelism Division, Tom Button. "With .NET-connected software and the power of Office, developers can create a broad range of applications that span from devices to datacenter servers, and now to Office."

Visual Basic for Applications -- Microsoft's current Office programming language -- will still be supported, but it lacks the security and deployment features found in the .NET Framework. Visual Studio Tools for Office will additionally support no-touch deployment, which permits developers to change or upgrade applications without end-user interaction.

Visual Studio Tools for Office is slated to ship alongside Office 11 in mid-2003. Microsoft has not yet detailed specific pricing or packaging for the tools.

Comments

View comments by with a score of at least

Huzzah! Gaping security holes that will haunt Office users for the rest of the whole "office experience". Office11 was doing fine until this came along side.

First post, word to your mothers.

Score: 0

|

Its amazing how people assume that a product will be insecure and full of holes. have you even looked at any MS products lately?
Prolly not, i'm sure you're using all that other software that has NO bugs and NO security holes... you're so lucky to be enlightened in such a way...

Score: 0

|

I use Windows 2000 Professional as my main OS and I'm well aware of the security holes it has. Linux, I'm well aware, has the same amount if not more than Windows it's just that people don't go trying to find holes in it. For the record, I'm an official beta tester for Office 11 and any time MS adds something like this what's the most common security hole? Buffer overflows. Just like everything else. No need to be such a prick.

Score: 0

|

the key question i have is why do they keep adding crap that hardly anyone will use...and boys behave...

Score: 0

|

oh, I'm sure plenty of people will use it, but 95% of them will be hackers using this "feature" to make new backdoor viruses.

Score: 0

|

Exactly my point. Glad at least someone sees the same side of the spectrum. =P

Score: 0

|

i wasn't trying to be a prick. Everytime there's an article on anything new that MS does, people are quick to either complain about it being bloated, full of holes, forcing customers to spend more money to update, etc. 99% of these people don't have a clue what they are talking about. I'm glad to see that you fall into the minority 1% that does know what you're talking about. I apologize for sounding like a prick.
I would however like to point out that something like this is a GREAT addition for people that have been developing stuff for office while at the same time using .NET to develop other solutions. So even if it is likely to have a buffer overflow problem, i'm still glad they're adding it, and i think that the virtues of it need to be expounded in addition to the potential problems. The buffer overflows can be fixed (hopefully they'll get to them before the release..........right...) but a lack of a good programming feature can't just be fixed with a patch.
Again, i apologize for sounding like a prick.

Score: 0

|

I've been at a couple of large corporations now that have used so-called "Office Applications" as ways to leverage corporate data. I'm not too crazy in general about desktop apps for corporations because of the old DLL hell scenario. But slowly but surely the .NET self-describing assembly approach will help improve that (yes it will take years to get there). A couple of examples of what I saw in Office automation that seemed pretty cool were:

They distributed an Access app to the managers that dug Access that let them push data they'd gotten from the field into the corp database. Then a nightly app pulled data from the database and built an Excel workbook out of it, workbook with its own buttons that ran macros that gen'd reports and massaged the data. Then using CDO they emailed the workbooks to B-to-B customers across the globe. These guys that received the mailed workbooks were extatic about getting the latest and greatest data local and in a form they could work with.

In another Office Automation app, a corp had a bunch of legal documents that were required with each new customer relationship, tons of docs some of which were huge. Depending on the customer, the group of docs would differ but each individual type of doc wouldn't change much, just certain customer info and certain clauses that were relevant or weren't relevant. So a Word application was created. It pulled the metadata about the customers from SQL server and then drove Word to create the correct packet of documents with the correct customer-specific data inserted into the templates.

Maybe there's a better way to do this stuff, but damn, it sure seemed like Office automation met their requirements well. So if you can buy off on the value of that sort of application for corporations, the next question is should the language that enables that stuff basically freeze at the 1999 level (VBA/VB6) or should it move forwards into full object orientation and all the other benefits provided by .NET? I think it's great that Microsoft will .NET-enable their office suite.

Score: 0

|

While I can see the value of this type of automation for large businesses, what value would it have for the average home user that uses Office for day to day tasks, or even most smaller companies that don't need this functionality? If Office 11 is going to have the ability to run these applications, then I hope that it comes turned off by default, possibly with a prompt to the user when a document need this functionality. Otherwise, I stand by my previous statement that this is going to be another great way for people to write viruses, at least as bad as VBscript, possibly even worse. This is the part that worries me; "Visual Studio Tools for Office will additionally support no-touch deployment, which permits developers to change or upgrade applications without end-user interaction.". It sounds as if once a document is on a user's computer, the author of the document can update it as they see fit, and since these documents are in essence applications, the author can change what the application does WITHOUT THE CONSENT OR KNOWLEDGE OF THE USER!! Am I the only one that sees a HUGE security issue here?

Score: 0

|

I would guess (i stress guess) that the .NET security framework stuff will be included in this stuff. Meaning that applications you get from the web won't have access to file systems, things like that. ALl the normal .NET security stuff. This would also mean that in a business environment, it could be set to allow developers/admins/etc to modify stuff automatically, because trusts and things like that would be established. But for the home user, there would be no domain trusts, etc, and only applications created on that computer would run with full permissions by default.
I remember running into this with a .NET application i wrote for class last year... i was gonna show it to the TA, so i emailed it to myself. Unfortunately i used Webmail to check my email from his computer, and when i downloaded the app to his computer, it didn't have the right security permissions because it was from the web. Pain in the butt for me, but if i were a dumb user and was downloading apps off the web, it could have saved me virus problems.
HOPEFULLY, this sort of thing is built into the Visual Stuido Tools for Office as well.

Score: 0

|

PDC 2009: What have we learned this week?

There was the freebie that no one will forget, the heebie-jeebies courtesy of Scott Guthrie, and a teensy bit clearer picture of how this cloud thingie should work.

Live report: Will Google Chrome OS change Linux?

The mysteries of just what Chrome OS is, and how much of an operating system it truly is, may be resolved today.

PDC 2009: Microsoft cares about Web browser performance

The effort to give users of the world's dominant Web browser the impression of quality, is a personal one for the man who leads that battle.

Nokia re-affirms its commitment to Symbian, sort of

Maemo won't necessarily be replacing Symbian in the Nokia N-Series, but that's definitely a place where it will be found.

E-book readers will be in short supply this holiday season

E-readers are hot this year, and a lot of compelling new products have been released, but are there enough electrophoretic displays to go around?

Sony looks to finally open a single storefront for downloads

Sony has had many different download portals for movies, music, e-books, and games, and now it's looking to make a single shop for all of it.

Tuning out the tablet: Time to give the endless speculation a rest

Wide Angle Zoom: Wishing and hoping and thinking and praying....won't put an iTablet on the market.

Five improvements for IT managers in 2010

If businesses are to improve their efficiency for next year, they need to stop and reassess the basic tenets of their job.

AOL's spinoff from Time Warner to shed 2,500 jobs

As AOL moves toward become an independent company again, it will cut nearly a third of its workforce.

Gartner: SMS-based money transfer will be bigger than mobile browsing, search

Gartner issues its predictions for the 10 things our phones will be doing in 2012.

Don't forget to upgrade to Firefox 3.6 beta 3 today

Mozilla has released the latest beta its Firefox 3.6 browser software, just over one week after beta 2.