Sebastien Notebaert's Q&A profile

• Microsoft ISV Community Center Forums Length of an Excel Macro?

  I am writing a macro but I'm not sure if it is getting too long or if there is such a thing as too long. This is what I am asking it to do: 1. open a text file and convert to excel 2. save the full file in a folder 3. delete some colums and records then resave in a new folder then resort the coulms change some data and save in a 2nd folder then close 4. reopen original file and delete different colums and save in a third folder resort the colums, change some data and save in a 4th folder then close Is this too much to ask one macro to do Am I just asking for trouble Should I split it out into multiple smaller macros ...Show All

• Visual Studio Team System Auto generated code has underscore

  Hi how do you fix this rule when VS & crystal reports auto generated code adds the underscore as in " ugdListing_DoubleClickRow" , which is the doubleclickrow event of a grid control. Duncan Hi Duncan, There are couple of ways to get your code not to have violations against this rule: You can set your winforms designer to emit the code generated for your ugdListing as private code control by changing the "Modifiers" property to "private". FxCop won't run naming rules on private code Instead of double clicking on the control to get a method name autoge ...Show All

• Visual Studio Team System Easy Question (Hopefully) - where is the process home page?!

  Finally got Team System RC installed successfully, installed the Team Explorer on my development machine, attached to my team server and created a new Project - so far so good. After the project was created, Visual Studio displays the Process home page that shows all the roles, work items, etc. Unfortunately, after closing Visual Studio, that tab is no longer opened, and I can't find how to get that web site to display again! Any help is appreciated! Thanks, Bob Willer Hi Bob, You could simply right click on the project that you have just finished creating and select "Show Project Portal" ...Show All

• Visual Studio Team System Renaming files under source control in VS.NET

  Is there an issue with this at all anymore In other words, if I rename a file under source control from within the VS.NET 2005 environment, will the file: a- be renamed correctly (and not deleted+created) in VSS b- retain it's history in VSS Thank you, Sammy In Team System Source Control, the item would both be renamed/moved correectly (i.e. rename is not a copy/add/delete old), and history would be retained. ...Show All

• Visual Studio On Stores, Editors & Models.

  There are a number of posts on the forum now about loading and saving models, including how to load models into stores, using one store for many models, and havin transactions that span changes to many models. There is still one gap in the information as far as I can see, and that is the relationship between editors and stores. When a file is openened in the designer an editor is created for that file (I hope I have the terminology right, please correct me if necessary...). The editor loads the model. Is the model equivalent to a document as seen elsewhere in the VS SDK Does the editor create a store for itself Can many editors be coerced in ...Show All

• Visual Basic Problem with Socket?

  It is possible to create a client/server system with sockets without having that to define an IP to connect itself to the server I have a system in vb6 but I am not obtaining to translate into net 2005 Thanks Bottom line is no. You could rephrase the question: Is it possible to send an e-mail to someone without knowing their address Having said that, you can 'broadcast' messages to everyone: this is really only useful to send out an 'is anyone out there ' message, and the server respond with an 'i'm here at xyz address '; the conversation will then continue through a connection established to that address. ...Show All

• Visual Basic Issuing commands through a console program (cmd.exe or telnet.exe)

  I can open a console program (cmd.exe) through VB.NET. Now how do I enter text based commands to that console I would assume that I have to take control of STDIN and STDOUT. I also need to capture the responses from the console to parse the result. Don't need lots of detail, just point me in the right direction. Ya, that was the first thing I tried. Doesn't work for me. Here is a snippet that I tested with. Shell( "cmd.EXE" , AppWinStyle.NormalFocus) Console.WriteLine( "cd\" ) str = Console.ReadLine() MessageBox.Show(str) ...Show All

• Visual Basic Com Interop problem with VB.Net project

  I have built a variation of the Ldap Authentication function referenced in http://support.microsoft.com/default.aspx scid=kb;en-us;326340#3 The problem i am having is accessing the resultant .dll Do I need to research and develop a "strong name" for the assembly   The properties are set to "Register for Com interop".  Is C# a better platform for building COM objects I know it is a little bit old of a question but I had the same problem and just found the solution so I think it can help somebody else. What you just need to do is register your dll using regasm http://msdn.microsoft. ...Show All

• SQL Server Where is Management Studio

  I have been working this for 2 days on my XP SP2 machine, AHHHHH !! I tried running the SQL Server 2005 Tools install, and kept getting SQL configuration checker error with WMI. What finally got me around that was installing VS 2005. {without SQL Express} Ran the tools install, but not Management Studio, only the Configuration Tools on my menu. What the heck, tried running the full install, got the database engine, but still no Management Studio. Tried uninstalling everything, everything is gone except the database engine. Tried re-installing, still no luck. Tried the command line to fix the shortcut to management studio as de ...Show All

• Visual Studio Express Editions Splash Screen not selectable

  I can't seem to change the splash screen under Project|Properties|Application|Splash Screen. Only my main form is visble in the list.  I've added a splash screen from Project|Add Windows Form. Any thoughts -Scott To revise my last, It's just intermittant.  No two ways work the same back to back.  Just takes some fiddling. ...Show All

• Visual Studio Team System "Edited by God" history message.

  We observed "Edited by God" message in history of work item. Is it joke of TFS developers http://photofile.ru/photo/toly/1294760/large/26995834.jpg Sorry to say, but this forum engine doesn`t have an option to upload the file. Although I don't have the link handy, I read a post sometime earlier this week (or late last week) that showed how to do exactly what you're seeing. Basically, it showed how to copy rich text into the history section to mimic an actual history entry. Maybe someone here has the link --- Jeff http://devmatter.blogspot.com/ ...Show All

• Visual Studio Team System App Tier - Error 32000 - setupwarehouse.log

  I cannot install Application Tier (Dual-Server deployment). Everything made exactly like described in the newest Installation Guide (April). Clean installation on Virtual PC. Tested platforms: Polish version of Windows Server 2003 Standard, English version of Windows Server 2003 Enterprise with SP1 - same error on both versions. At the end of the installation I still get the same error: Errorr 32000: The commandline '"C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\bisdwserver\bin\SetupWarehouse.exe" -n -s "TFDT" -d BisDWDB -c "C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\bisdwserver\b ...Show All

• .NET Development Remoting....Delegates....

  Hello Folks! I was trying to work on a remoting appication and i needed to write events such that the client or server in remoting should be notified if the other one closes down the communication. I was able to achive the client side notification but the problem is that when i try to add an event handler in the client so that the client is notified when the server exits, i get a error saying "Turn of custom error's on client.config". I am confused why cant i register a event on the client side. Awaiting Replies. Thankyou for reading, don't know if this is exactly what you want but take a look at ...Show All

• Visual Basic How to use Textbox to serch a database & dislaying in datagrid

  Hi everyone,  my roblem is that, I want to use the textbox to type using it textchange event when one type it search the database for the matching data as it found each data it display then in a datagrid and the pointer point to the record. any help our surgestion will do thanks all You may want to think about what your trying to do - putting it in a text changed event causes  the filter to be carried out every time the textbox changes -ie. every keystroke but this is doing a dynamic filter and this may be what you want.  However it is doing a lot of processing say if you have a long filter string. You may want to put a ...Show All

• Visual Studio Express Editions Using VB Express with a limited account

  I've installed this (it required admin privileges) and then tried to register on my limited account and it refuses to accept the key although it quite happily did on the admin account. When I run it on the limited account it tells me that I have 28 days left before it expires. Does this mean I can to only use VB Express as a superuser Seems a bit daft considering that Microsoft are currently trying to discourage lazy developers from requiring admin access. Hopefully someone can enlighten me. hi, i guess the 28 days left is for registeration, in your help  menu click register product vb express is ...Show All