-
Hello all, I have written a VSTO add-in for Excel 2003/2007, which works great on a machine where the .NET framework 3.5 is deployed. Unfortunately, one of the users works in an IT-restrictive company, which has "not tested" the 3.5 framework, and is reluctant to install it. I tried to rebuild...
-
In the spirit of sharing things I wish someone had told me when I started with VSTO, I posted here an entry which describes what to do if you want to use satellite assemblies (i.e. reference pre-built dlls) in your VSTO Excel 2003 add-in project. If you just follow the msdn Walkthrough on Deploying Visual...
-
Greetings. This is not a question, but relates to my (successful!?) experience creating and installing an Excel add-in using VSTO, VS2005 Professional, VSTO 2005 SE for Windows XP and Office 2003 for multiple users. While this may be old news to some people, I haven't come across 'plain English'...
-
Hello once again. It seems that every step of the development cycle of my project ends up as a post here ;) I'm at the distribution part of the development of my code. I have debugged and tested on my development machine and I am satisfied that there are no bugs preventing me from releasing a 'beta'...
-
Just to clarify: I have two machines I am developing on: VSTO Second Edition with Visual Studio 2005 Professional on Vista Ultimate and developing for Excel 2007 VSTO Second Edition with Visual Studio 2005 Professional on XP Professional and developing for Excel 2003 The problem with the Tag property...
-
Hello again. Just an update on what is happening with this problem - and now a solution! I commented out the mnuItem1.click event, cleaned and rebuilt the solution, then debugged. Only Form2 loaded. The fact that Form2 loaded on an event that was commented out was curious, so I searched the entire document...
-
Hello Nick and Dennis. Firstly, thank you for your replies. I am using VSTO Second Edition. Using the Try ... Catch ... End Try no errors reported, but 2 forms still showed. I am getting the 'error' in Excel 2003 and Excel 2007 Stepping through the code did not highlight anywhere that two forms...
-
Hello. Since Dennis helped with my original post I have been happily converting an existing VBA add-in to VSTO. This has given me plenty of practice - as well as getting use to the VSTO way of doing things. I have come up against a problem that I can't seem to resolve, and Google hasn't helped...
-
Dennis, Thanks for the reply. I was able to create the menu required, however your example has shown me how to streamline it using With ... End With blocks for CommandBarPopup sub-menus. I am currently developing for Excel 2003, but will be looking to upgrade to 2007 once demand for it increases. I'm...
-
Morning to all. I have been developing Excel code for some time, and while no expert, I can connect Excel with SQL and enforce security with Active Directory. Now I am looking to move to VSTO, but no matter what I read, or how much time I spend developing code, I just can't seem to get my head around...