Denis Pitcher's Q&A profile

• Microsoft ISV Community Center Forums Adding a command button to the toolbar or menu bar in Excel?

  Hi I'm wondering is it possible to add a command button to the toolbar or menu bar in Excel using VBA I came across an excel file before in work that somebody had setup this way but not sure how to go about it! I basically have two buttons that I would like to have added to the toolbar or menu to make the sheet tidier and enable the user to see all the data without having to move the buttons etc. http://i102.photobucket.com/albums/m82/sc0ttb_2006/excel_buttons.jpg Any ideas folks Thanks, Scott That's great - thanks a million! I was playing about with it and had basically something similair but in a new module which was a lot of unnecessary code. One problem though - i can ...Show All

• Visual C# Error reading the HTTPListenerRequest InputStream

  Hi Friends, When I try to read the incoming client request data using the HttpListenerRequest.InputStream property, I'm getting the following exception (not everytime) - System.Net.HttpListenerException: The I/O operation has been aborted because of either a thread exit or an application request Server stack trace: at System.Net.HttpRequestStream.Read(Byte[] buffer, Int32 offset, Int32 size) at HttpListenerLibrary.HttpListenerWrapper.ProcessRequest() in C:\AcsSim\HttpListenerLibrary\HttpListenerLibrary.cs:line 901 at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Mess ...Show All

• Visual Basic String.Aplit Method

    hello there, please does anyone know how to create a non visual class that has the behaviour to count characters, words, alphabets, vowels, consonants, digits i am working on a form that needs a class to be added in other to be run. it involves counting i.e words, characters e.t.c as above. i have an idea of how to add a non visual class but the problem is how to put the behaviours (codes) for counting characters, words e.t.c thanks Babalicious, The following example demonstrates how to split a string at its spaces. Dim TestString As String = "Look at these!" ' Returns an array containing "Look", "at", and "these!". Di ...Show All

• Windows Forms Setting the ScrollBar position

  Hi! I have a Controller which AutoScroll property is set to true. I'd like to start the controller with a specified position for the AutoScroll, so I want to set manually the AutoScrollPosition, but when I set the new value, it does not work. Could anyone help me thanks. Hi, This article may help: http://support.microsoft.com/default.aspx/kb/829417/en-us Thanks ...Show All

• Windows Forms windows forms 2.0> when close button on title bar is clicked

  windows forms 2.0> when close button on title bar is clicked, it should display message box for confirmation if yes, window should be closed when the window is in maximized state, the maximize button changes in to restore button thats the reason why maximizebox property to false doesnt work, now i am unable to disable this restore button pls suggest ...Show All

• Windows Live Developer Forums 8013150a when output files.

  hello guys, i'm tring to write an addin to save the chat log into txt files, but i got the security error 8013150a. can i fix this or the io operation is just currently not allowed hi I'm having the same troubles can anyone explian me how to save the text that is hold by 5 TextBoxes. I'm Writting an Add In for the msn and I need to save that text in anywhere ...Show All

• Visual Studio Team System check out script after build with tfsbuild.proj postbuild

  Dear all i am prity new with the tfs and i will appreciate you kind help i whish to write a little script in the tfsbuild.proj file that after a specific build which i created, tfs checks out a file that located somewhere in the server i used the <exec> and the <target name="..."> and didnt succeeded in can someone help me pls!!!! Ron Add an build event to execute a batch file , the batch file should execute TF checkout command . you can use VS2005 extensibility kit for adding an event . I think it has a power toy to do that ...Show All

• Visual Studio 2008 (Pre-release) Problem sending inherited objects

  Hey! I have the fallowing class: [DataContract] public class MyItem { private string mInfo; [DataMember] public string info { get { return mInfo; } set { mInfo= value; } } Then o inherit this class to: [DataContract] public class MySubItem : MyItem { private int mId; [DataMember] public int info { get { return mId; } set { mId= value; } } I am now creating 5 object of each type(MyItem and MySubItem), this 10 objects are added to a dictionary that are of the typ MyItem like this: Dictionary<int, MyItem> To add the ...Show All

• Visual C# Datagrids: How to format boolean values?

  Hi All, I'm working with a Datagrid in which one of the columns is populated using a boolean value (bit in SQLSrv). Is there a way I can format this value to show a more user-friendly message . I would like to display 'Activate' for False and 'Deactivate' for True. Thanks in advance, You can use views for that. You can use Sql server view or runtume DataView. At the end you can use sql statement to fill your table, but not taking data with select *, but with some column change. ...Show All

• .NET Development Get the Disk drive information in vb.net

  I want to know the free space, used space in the particular drive of my hard disk by vb.net program. so can anyone help me in this issue sure. in .NET 2.0 there is a DriveInfo class in the System.IO namespace   For Each curDrive as DriveInfo in My.Computer.FileSystem.Drives    If curDrive.DriveType = DriveType.Fixed Then       dim theFreeSpace as long = curDrive.AvailableFreeSpace       MessageBox.Show(theFreeSpace.ToString())    End if Next   You can of course get the name of the drive using the name property to check to see if it is the drive you are after does this help ...Show All

• Visual Studio Visual Studio 2005 default install

  Is there a way to install Visual Studio 2005, in Windows XP Pro w/SP2, so that when a user logs in, they don't have to choose the default environment settings I would like to get this setup on our lab machines, where the general environment settings are already set as the default. As of right now, it takes some time for the computer to configure each time they log on since we don't have roaming profiles, and profiles aren't kept on the machines. I tried to copy the ntuser.dat and ntuser.dat.log files over from a profile that had the software configured into the default user profile, but that didn't seem to work quite right. Any suggestions would be appreciated. Thanks. Hey there, Actually, there is. Y ...Show All

• Visual Studio 2008 (Pre-release) Canvas.Get...Whatever

  Is static Canvas.GetLeft (GetRight/Bottom/Top) the only way to detect position of UIElement related to Canvas Why not to ask UIElement (FrameworkElement) its position, as it was in previouse release What are the reasons of it You say: That's fine, but if I have my UIElement docked in something else, then Canvas. We can not attach to all elements...   I don't quite understand...perhaps you can give me a concrete and detailed example like this:   When I have: <DockPanel>     <Button />     </Button /> </DockPanel> And I try ____, I expect ___ to happen, but ____ happens. Thx, Rob ...Show All

• Visual Studio Getting the Linker Command Line Arguments from the Property Pages programmatically

  I am attempting to compile and link C++ projects using C#. When I have the hard-coded compiler and linker command line arguments, this works correctly, so I am on the right path. I am looking to be able to get the command line arguments for both the compiler(C/C++) and Linker Property pages from the vcproj file (which is not the current solution). By the command line arguments, I mean the full set of options as they are available when you open the Property Pages | C\C++ | Command Line -> All Options:. Is this possible I have been looking into using EnvDTE but was getting horribly confused and unsure of where to turn with what little code I had. I then began looking into the VCProject, VCProjectEngine, VCCLCompilerTool and VCL ...Show All

• Software Development for Windows Vista Context Menu - Workflow Designer Sample

  Hi. I am building on top of the Workflow Designer sample and am trying to add context menus to the activities on the design surface. I have been able to use ISelectionService to get close to the intended effect but did not find a way to determine when a right-click raises the event and when a left-click raises the event. I think that maybe ISelectionService is not the correct approach, but am having trouble figuring out where and how to create and bubble up the event. Thanks in advance! Look at the WorkflowDesignerMessageFilter class in the docs. The docs will point you to a sample in the SDK. This class has a method, OnShowContextMenu, that will signal you to show your context menu. You can then eithe ...Show All

• Visual Studio Team System Adding a user to all team projects

  Perhaps I am not searching correctly in this forum but I cannot find an answer. Is there a way to add a user as a Reader for all team projects in one step rather than having to add the user individually to each team project Thank you! Stephen Thank you very much Adam for your reply. Although I like you first suggestion and will likely do that, I would love to see some sample code for learning purposes. Thanks again! Stephen ...Show All