Darryl Collins
Darryl.Collins at coles.com.au
Wed Apr 22 18:33:36 CDT 2009
Not going to happen. Excel 2007 uses VBA just like the other version, the VBE is *exactly* the same as it was back in Office97 (no surprises there I guess). Actually moving from earlier versions of XL to XL2007 has been pretty painless and all the VBA code has worked without error so far. Wish I could same the same of MS Access, which has been a real pig to use. oh well... So, no - dropping in .Net into an XL2007 Code module is not going to work. cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Thursday, 23 April 2009 3:54 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Office 2007 and .Net Ok, I think this is what they were thinking. But what they really are asking for is that they don't want to have to build an interface, they just want to plop a .NET object/function into an Excel macro (not as a .dll, but just pasting the code (so they can tweak it as they use it)) and use the spreadsheet as the interface. >From what I saw, it doesn't look like VSTO actually does that, just provides a nice platform to interact between the two. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Murphy Sent: Wednesday, April 22, 2009 12:06 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Office 2007 and .Net I believe that there is a package called Visual Studio Tools for Office 2007 that makes it easier to integrate VS apps with Office. Look at the Office web site. I am not sure you even need that as it is easy to build dlls in VS and hook them into Office apps if you want to add some functionality VBA can't provide. Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Drew Wutka Sent: Wednesday, April 22, 2009 9:38 AM To: Access Developers discussion and problem solving Subject: [AccessD] Office 2007 and .Net Since I was promoted to being the Network Systems Admin here, I have done very little development, so I feel a little out of the loop. The other day, someone asked me when we are planning on moving our company to Office 2007. Right now, we have no real plans to do so. We are currently using Office 2003. The people that were asking are using Visual Studio 2005, to work on a custom project. They want to be able to use Excel to test their code. More specifically, they want to take the code from Visual Studio (I believe they are coding in VB.NET), and paste it into an Excel macro to test it...... Now, from my understanding, that won't work, because Excel uses VBA, not .NET, so the code won't work like that. I was being told that they though Office 2007 would work like that, but as far as I know, Office 2007 still uses VBA. Now, I know that you can interact (with any version of Excel or another Office application) from .NET (or almost any programming language). But they specifically want to be able to take .NET functions/classes and use them in a macro in Excel (without compiling as a .dll). Am I correct in my assumption that 2007 still uses VBA, and not .NET for it's macro language? And does anyone know if/when Office will be moving to the new language structure? Drew The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI Business Sensitive material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com This email and any attachments may contain privileged and confidential information and are intended for the named addressee only. If you have received this e-mail in error, please notify the sender and delete this e-mail immediately. Any confidentiality, privilege or copyright is not waived or lost because this e-mail has been sent to you in error. It is your responsibility to check this e-mail and any attachments for viruses. No warranty is made that this material is free from computer virus or any other defect or error. Any loss/damage incurred by using this material is not the sender's responsibility. The sender's entire liability will be limited to resupplying the material.