index > Visual Basic for Applications (VBA) > .Net Version in the future?

.Net Version in the future?


Hello, I am wondering are we going to have a .Net Version of Office in the near future. The most important function I want to get out of it, is the multiple library version control. This probably not going to help my current version issues, but I hope we start to using .Net multi-library-version-control as early as possible for the future. Thanks.
magicalclick

Hi, yes the next version of Office will take advantage of .NET (Office 2007), although I'm not sure how they are going to do it. I'm under the impression that there might not be a development IDE and instead you need to use Visual Studio for development.

You can use .NET right now for developing with Office. There is a Visual Studio addin pack, VSOT (Visual Studio Office Tools) I think it's called that lets you develop SmartDocuments and other things. It's fairly expensive so I haven't tried it out.

You don't even need to use that either, you can use COM Interop to get VBA to call .NET assemblies. I wrote an article about it on my old blog . http://dsmyth.blogspot.com/2006_03_01_dsmyth_archive.html The code examples aren't there though. I'll try and remember to port it, and the examples, across to my new blog.




www.dsmyth.net/blog
Derek Smyth
reply 2

You can use google to search for other answers

 

More Articles

• suppress content overwrite message in TextToColumns?
• Size Form to fit user resolution
• Convert UTC date to mm/dd/yyyy hh-mm-ss
• go to next line?
• Trying to create a global variable
• Updating Hyperlink Addresses in VBA (MS Access)
• Outlook 2003 VBA - AdvancedSearch in a personal folder (*.pst dat...
• VBA Excel - Using FindNext function
• how to delete all names in workbook?
• Excel to PDF
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

• Find & Replace Macro - Reading from
• [OTP] VBA Using combobox in Excel
• Selection property
• command line parameters to VBA in PPT?
• Dialogsheets vs Userforms
• Browsing Selection.InlineShapes forces W
• Excel: Email Macro help
• vlookup on unions
• How do i use an addin in WORD?
• converting from VB 6 to VB.net
• VBA: read/write chinese words
• Retrieve IBM Workplace Forms data into E
• i want a code for file transfer by ws2_3
• Runtime error 1004 when adding a seriesc
• Outlook 2003 VBA - AdvancedSearch in a p

Hot Articles

• Selection property
• .lookin =
• Excel::NetDDE and DDEShare
• After_Save Event???
• Question about ADO and Access
• SELECT syntax in VBA for retrieving info
• Linking tables to databases in code
• IIf function within MS Access
• Clear Excel object
• To find Whether a value in a cell is pas
• Acces functions in my ouwn services appl
• Merging another document into a merge do
• Using the API of Visio to open a Custom
• Please help me to print the label for th
• Number formatting

Recommend Articles

• Excel COMBOBOX data sources
• Textbox won't keep new values after work
• Deleting tabs when a cell is emptied
• Cannot close all instances of excel afte
• MS Access VBA - Controlling Textbox in F
• Is this possible? (newby needs help with
• Reading a .LBD file
• Exporting Text to Webserver
• Task Scheduler
• How to change the DisplayAlert Response?
• Executing an insert statement in VBA
• wrong count of Records in Access.Form
• Returning the Server Referral By DFS link
• web query failure, On Error didn't work
• Standard Difference Function