Joe H's Q&A profile

• Microsoft ISV Community Center Forums How do I execute code when I open a workbook?

  I need to know how to start a VBA script when I first open a workbook without having to do anything else to activate it. Any help on this would be greatly appreciated. Hi, put the code in the Workbook_Open event. Select 'ThisWorkbook' in the project explorer and paste the following, any code you put in there will run when the book is opened. Private Sub Workbook_Open() End Sub ...Show All

• Visual Basic XML, Excel in vb.net

  hello, i never deal with this issue before. i want to generate the excel file from a datagrid. after reading some posting, somebody talk about xml, and some are excel. i totally confuse. it i must convert it to xml first then conert second time to excel or i can just convert it to excel directly Anyone know about it smith ...Show All

• Visual Studio Express Editions system colours

  Hi, I have a textbox who's backcolour property is set to system colour menubar. How do you choose this colour(menubar) within code There seems to be no option in the list provided Ron Hi, look at SystemColors class: TextBox1.BackColor = SystemColors.MenuBar; Andrej ...Show All

• Visual Basic Page_Load called twice.

  Hi, Does anyone know why a Page_Load would be called twice on a page when requesting an aspx page I am using .Net 2.0 with the new .net 1.1 compilation model installed. Whenever I request a page, the Page_Load on the aspx page appears to be called twice, so does the Page_Load on and user controls added to that page. Without some source it is difficult to know exactly when and where your problem is occurring. It could be you having the Page_Load function wired up twice, or even you causing a postback without knowing it. That being said though you may have better luck in asking your question over on the ASP.NET forums where the folks there tend to think in a more ASP.NET centric sort of ...Show All

• Visual Basic AudioPlayMode WaitToComplete fails

  My .Computer.Audio.Play( "c:\mymusicx.wav" , AudioPlayMode.WaitToComplete) The above works for .wav files where the music is fairly continuous, but when there are quiet gaps (about 6 secs or more) between songs within the same .wav file, the statement exits during the first quiet gap, rather than continuing to the end of the file. (Players like Itunes play the .wav file correctly to the end). I have Visual Studio 2005 v8.0.50720.42 Hoping someone can explain this. thanks for suggestion, but the problem happens with an explicit .wav file. I created a test .wav file by recording the C major scale from a keyboard. Each note was held for about 1/2 second, with a 5 second ga ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. System.Enum.GetValues() doesn't exist on XBOX360 ?

  Hello, I'm happily testing my game on the XBOX360, but I'm encountering a few issues. First I'm a bit dissapointed to see that Input.Mouse is not defined in Microsoft.Xna.Framework.Input on a "XBOX360" project, thus it doesn't compile. I would have assumed that PC stuff like inputs would just be ignored on the XBOX... How can tests the target platform at build time Second, and most important, I was relying on Enum.GetValues() (Windows build) to get the numbers of items in an Enum list. Like this: static public Texture2D[] sprites = new Texture2D[Enum.GetValues(typeof(BulletType)).Length]; However, when trying to build a XBOX game I get this error: Error 1 'System.Enum' does not contain a definition for 'GetValues' D:\LG-XB ...Show All

• .NET Development Using reflection to access an object

  I'm new to using reflection, and having a hell of a time with it. What I need to do is refer to a textbox by using a string. I have a collection of textboxes with the names of txtL1Name, txtL1NS, txtL2Name, txtL2NS. So, what I'd like to do is store the "txtL1" or "txtL2" prefixes into a string variable for use to refer to various textboxes. So, what I've been trying to do is something like: string tbPrefix = "txtL1"; Textbox textbox1 = Type.GetType(tbPrefix + "Name").GetField(tbPrefix + "Name") as Textbox; textbox1.Text = "Foo"; Obviously this hasn't been working for me, and I've tried changing the textbox1 object into a FieldInfo object, as it couldn't be converted into a textbo ...Show All

• Windows Forms HelpProvider - Line break & Min/Max

  Hi 1. My mainform is a "FixedDialog". It has the MinimizeBox=True and MaximizeBox=False. Is it possible to have the help button " " left to the MinimizeBox It only turns up if I set both MinimizeBox and MaximizeBox to False. :| 2. Is it possible to have line-breaks in "HelpString on hlpProvider" in the Property Window If I write "This is\nmy text", "\n" is not read as a line-break. (The same for the "Text" property of the Label component) Kind Regards In C#, make that: this.helpProvider1.SetHelpString(this, "hello\r\nworld"); ...Show All

• Commerce Server Editing order data in Customer and Orders Manager

  One of our client's requirements is to be be able to have staff manually change the order status of the order forms and line items using the Customer and Orders manager. Can this be done "out-of-the-box" or do we need to change the source code Thanks in advance Chris Pearce Hey Chris, You cannot manually change the order through the Customer and Orders Manager, out of the box. If you need to be able to do this, you will have to modify the source code. As an alternative, you could use the Commerce Server 2007 BizTalk Adapters to modify an existing order. Let me know if you have anymore questions/concerns. Thanks Alan ...Show All

• Windows Forms Colour selection and Drawstring in VB Express

  I am using Drawstring to print some stuff on labels. However, it has just become apparent that will will need to be able to let the user select a colour. No problem, the FontDialog does this, just like it does for font and size. I can assign a variable with the color returned by FontDialog but I can't use this variable in Drawstring. It seems you can only specify a specific system colours. I also can't declare a variable of type brush and assign a colour to that unless it's a specified colour. Could someone tell me please how I can use a colour seleted from FontDialog without 10 screens of Select Case statements Thanks, Rich You need to create a brush from the selected color to be u ...Show All

• Windows Forms Visual Web Dev. 2005 data entry and stored in database

  Hello, Just started using/learing Visual Web Developer 2005. What im looking to do is: 1) Have a login page x user goes to data entry y user goto reporting page pulled from data entries [or x user see's different menumap as y user] <-----might be a "nice" method Only authenicated user allowed access 2) Create a nice user interface for data entry <check boxes, radio buttons, drop down's, validations,submit>. Also a link to a DetailView grid for all data entered <for confirmation data was entered correctly> 2a) Once data is submitted <postback>, how can I automatically make all the fields go back to the defa ...Show All

• SQL Server "loop" a package in script task?

  In Dts you can loop a package by creating an Active-X script with something like this ... "oPackage.Steps("DTSStep_1").ExecutionStatus = DTSStepExecStat_Waiting" "oPackage.Steps("DTSStep_2").ExecutionStatus = DTSStepScriptResult_DontExecuteTask" What is the way to do in SSIS Depending on a condition i want to rerun my package but have not found a smooth way to do it. I guess you can do it in a better way than using the ActiveX Script Task have a nice day /Erik I think the For loop container can help on that (you can place a Execution package task inside to call another package).   http://msdn2.microsoft.com/en-us/library/ms139956.aspx I know there is a lot of info in the web, so do a ...Show All

• Visual Studio Team System VisitMethodCall

  Hi Friends, I realized that when looping on InstructionList I have SourceContext working, but how I get SourceContext working from inside an overrided VisitMethodCall or other Visit* Any directions please Thanks in advance Washington Moreira Look at the relevant SourceContext hanging off the node you're visiting. These are only sparsely populated, currently, due to an incompleteness in the metadata reader. We've fixed this in FxCop 1.36 but, as always, I have to warn you that writing against the Method.Body is a guarantee of future breaking changes. We are working with a couple of teams internally right now to define the right method body representation for analysis. The current one is problematic, due to its nesting. ...Show All

• Visual Basic Send output to stdout from gui app...possible?

  I have a simple vb.net gui application (an alternative file requester in a form) that I would like to run from the command line. It executes fine, but I find that I cannot send any output (a string representing the file selected) to the command line upon completion. It appears that "console.writeline" doesn't actually write to the console Any suggestions as to how to send info back to the console window upon completion Keep in mind that this is a gui app (not straight console). just did this video for you: http://www.spapps.co.uk/msdn/forums/vids/ConsoleGUI.wmv http://www.ai2005.pwp.blueyonder.co.uk/ConsoleGUI.wmv - if the above link doesnt work ...Show All

• Visual C# Embed Excel in WebBrowser on DotNet Form

  I am able to embed Excel into a WebBrowser on a dotnet form on my Dev machine but on a client machine an instance of Excel starts in it's own window outside of my form. I have use the MS example from MSDN and get the same result on non-Dev machine ISomeone remarked it maybe due to IE setting Does anyone know what the setting are and if they can be set on client machines to get my Dev and Non-dev machine to act the same Thanks Browser = new WebBrowser(); Browser.Dock = DockStyle.Fill; Browser.Location = new System.Drawing.Point(0, 0); Browser.Name = "Browser"; Browser.Size = new Size(223, 443); Browser.TabIndex = 0; pnlPreview.Controls.Add(Browser); this.ResumeLayout(); Browser.Url = new Uri(sPath + " \\myxls.xls " ...Show All