Search hydraulic structure. Code snippets for Visual Basic & VBA Programmers (Visual Bas. BLACk Viper. Introduction This information is valid for all versions of XP x86 (32-bit) running Service Pack 3. XP Pro x64 (64-bit) Service information and Configurations are also online. Before adjusting your service settings, ensure that you or your system has already installed all updates by “checking now” for any available updates via Windows Update. I cannot possibly test all configurations extensively (meaning, each persons specific computer needs), but what I can offer is what “works for me” and the obstacles I have came across so you do not have to discover them on your own.
Notes for a Happier Computer and User Do not use “msconfig” to disable services, type “services.msc” in the Run box instead! Table Header Information The columns are sortable. Configuration Information Automatic ~ With a service in this state, it will start at boot time. Service Dependency Abbreviation Information H ~ Windows XP HomeM ~ Windows XP Media Center Edition 2005P ~ Windows XP ProT ~ Windows XP Tablet PC Edition 2005. Importing Text Files. What to Do with VBA Using Files with the Open Command. Know Dot Net - Query an Excel Worksheet Without using Interop.
Many years back when I was first starting programming, my main duties involved data mining and reporting. Crystal Reports could usually make your reports pretty in a short amount of time, but Excel has a lot more power in many regards even though it's not supposed to be a report writer. Anyway, it wasn't long before I did a lot with Excel and Automation. When .NET came out, I was working on a project where I had to read in some data from an Excel sheet and peg a few variable to the corresponding fields in the worksheet.
Out of impulse, I ran to Interop and a few hours later, my work was done. Then comes my friend ADO.NET. Here's how to do it... Notice that this code may look a bit verbose, but that's mostly due to error handlers and clarity. Anyway, I tried to comment what's going on but it's really quite simple. The R Project for Statistical Computing. Introduction to HEC-RAS. Prepared by Eric Tate Center for Research in Water Resources April 1999 Table of Contents Goals of the Exercise The primary goal of this exercise is to introduce you to channel flow using the HEC River Analysis System (HEC-RAS). By the end of this exercise, you should be able to: Import and edit cross-sectional geometry dataImport and edit flow data from HEC-HMSPerform a steady flow simulationView and analyze HEC-RAS output Software and Data Requirements The HEC-RAS program can be downloaded free of charge from the Hydrologic Engineering Center's home page at: HEC-RAS Hydraulics HEC-RAS is a one-dimensional steady flow hydraulic model designed to aid hydraulic engineers in channel flow analysis and floodplain determination.
. , which states that the total energy (H) at any given location along the stream is the sum of potential energy (Z + Y) and kinetic energy (aV2/2g). Starting a Project Importing and Editing Geometric Data and , and button. Cleaning Up. Hec-ras and mapping. A List of the Keyboard Shortcuts That Are Available in Windows X. This article describes the keyboard shortcuts that you can use to complete tasks in Windows XP. General keyboard shortcuts Click here to show/hide list Dialog box keyboard shortcuts Click here to show/hide list If you press Shift+F8 in extended selection list boxes, you enable extended selection mode. Ctrl+Tab (Move forward through the tabs)Ctrl+Shift+Tab (Move backward through the tabs)Tab (Move forward through the options)Shift+Tab (Move backward through the options)Alt+Underlined letter (Perform the corresponding command, or select the corresponding option)Enter (Perform the command for the active option or button)Spacebar (Select or clear the check box if the active option is a check box)Arrow keys (Select a button if the active option is a group of option buttons)F1 key (Display Help)F4 key (Display the items in the active list)Backspace (Open a folder one level up if a folder is selected in the Save As or Open dialog box) Microsoft natural keyboard shortcuts Click here to show/hide list.
AJP VBA Coding. VBA Code VBA coding techniques, solutions and examples RibbonX Designer for 2010 VBA add-in with which to create ribbonx code for both 2007 and 2010. Requires Excel 2010 to access customUI14 section. Chart Labeler for PowerPoint VBA Add-in to link chart data labels to cells. Chart Text Mover VBA Add-in to move chart text items. Userform Textbox Contextual Menus A class object to add a Contextual Menu to textboxes RibbonX Visual Designer VBA add-in with which to create ribbonx code. NB. Axis labels using textboxes VBA code to add and align textboxes in place of Axis labels Listbox move items class code A class object to handle moving list items either up and down or between two listboxes.
Userform Clock The hands are adjusted by moving the mouse over the dial Anchor controls and resizing userform A class to dynamically resize controls and userform using user definable anchors Userform splitter class A class to dynamically add splitter controls to userform Resize userform Userform drawing (Excel 2000 and above) VBA Tips Build an Excel Add-In. About Add-Ins An Excel Add-In is a file (usually with an .xla or .xll extension) that Excel can load when it starts up. The file contains code (VBA in the case of an .xla Add-In) that adds additional functionality to Excel, usually in the form of new functions. Add-Ins provide an excellent way of increasing the power of Excel and they are the ideal vehicle for distributing your custom functions.
Excel is shipped with a variety of Add-Ins ready for you to load and start using, and many third-party Add-Ins are available. This article shows you how to write a custom function using Excel VBA and how to save and install it as an Add-In. In the Excel tutorial Working Out a Person's Age - An Introduction to Nested IF Statements I showed how to use IF statements to calculate someone's age from their date of birth. If you are already comfortable with writing custom functions, you can go straight to the section explaining how to save your UDFs as an Add-In.
Write the Function Step 2: Enter the Code.