Split first and last names in Excel VBA

When data is formatted like this: Colbert, Mike test@test.com BAIS IS And you want it like this: Mike Colbert test@test.com BAIS IS Sub dataCleanUp() Dim name As String Dim email As String Dim major As String Dim track As String Dim i As Integer ‘ loop counter Dim nStudents As Integer ‘ row counter Dim … Read more

MS SQL script to create database and add data

This Microsoft SQL script was used to create a database table named colbert_stateFacts with fields stID, state_name, state_capital, state_code, state_bird and state_flower. The script then inserted records into the new table. CREATE TABLE [dbo].[colbert_stateFacts] ( [stID] [int] IDENTITY(1,1) NOT NULL, [state_name] [nvarchar](50) NOT NULL, [state_capital] [nvarchar](50) NOT NULL, [state_code] [nvarchar](2) NOT NULL, [state_bird] [nvarchar](50) NULL, … Read more

Add A New Worksheet Using Excel VBA

Add a new worksheet named “Mike”… Worksheets.Add.Name = “Mike” Add a new worksheet named “Mike” as the first worksheet, before all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(1).Name = “Mike” Add a new worksheet named “Mike” as the last worksheet, after all the other worksheet tabs… Worksheets.Add(Before:=Worksheets(Worksheets.Count).Name = “Mike”

Configure Syslogging On A Cisco Device

Configure a syslog server, then enter the following commands on the device you want to monitor… config t logging ‘ip address of syslog server’ logging trap informational

Markdown Code Block Sample

Test to see if Markdown works: Some text before the code block. <%@ Page Title=”” Language=”VB” MasterPageFile=”~/msci3025.master” AutoEventWireup=”false” CodeFile=”ThankYou.aspx.vb” Inherits=”ThankYou” %> <asp:Content ID=”Content1″ ContentPlaceHolderID=”head” Runat=”Server”> </asp:Content> <asp:Content ID=”Content2″ ContentPlaceHolderID=”ContentPlaceHolder1″ Runat=”Server”> Thank you for participating in our survey! </asp:Content> Some text after the code block.