walkergv

'Code for Upper Case

Sub UpperCase()
Dim objCell As Object
For Each objCell In Selection
objCell.Value = UCase(objCell.Formula)
Next
End Sub

'Code for Lower Case

walkergv

Function MakeModifiedBroadMatch(rng As Range, RemoveCommonWords As Boolean) As String
    Dim WordList() As String
    Dim CommonWords() As String: CommonWords = Split("how,do,i,with,in,a,to,the,for,is,of,and,are", ",")
    Dim i As Integer
    Dim x As Integer
    Dim ContainsCommonWord As Boolean
    Dim ModifiedBroadMatchKeyword As String
    
    
    WordList = Split(rng.Value)

walkergv

Function ShowMatch(Keyword As String, ByVal MyRange As Range) As String
    Dim Delimiter As String: Delimiter = "-"
    Dim Temp As String: Temp = ""
        For Each Row In MyRange.Rows
          For Each cell In Row.Cells
             If InStr(Keyword, cell) > 0 Then
                Temp = Temp + Delimiter + cell
             End If
          Next cell
        Next Row

walkergv

Sub CategoryToSheet()
    Dim rng                 As Range
    Dim Category            As Range
    Dim List                As New Collection
    Dim Item                As Variant
    Dim i                   As Integer
    Dim rngLinkCell         As Range
    Dim strSubAddress       As String
    Dim strDisplayText      As String
    '

walkergv

<?
$curl = curl_init();
curl_setopt_array($curl, array(
    CURLOPT_RETURNTRANSFER => 1,
    CURLOPT_URL => 'http://www.google-analytics.com/collect?v=1&tid=[UA-XXXXXXXXX-1]&cid=[RANDOM_INTEGER_OR_GUID]&t=event&ec=[EVENT_CATEGORY]&ea=[EVENT_ACTION]&el=[EVENT_LABEL]',
    CURLOPT_USERAGENT => 'Vanity-URL-Tracker',
    ));
$resp = curl_exec($curl);
curl_close($curl);
header("HTTP/1.1 301 Moved Permanently"); 

walkergv

// ==UserScript==
// @name      Google Tag Manager Test Script
// @namespace  http://www.tikodigital.com/
// @version    0.1
// @description  Code to Run Google Tag Manager Client Side 
// @include      *domain.com*
// @copyright  2014 Tiko Digital
// ==/UserScript==

var actualCode = '(' + function() {

walkergv

########## - BEGIN - remove www version of site
RewriteCond %{HTTP_HOST} ^domain\.com$ [NC]
RewriteRule ^(.*)$ http://www.domain.com/$1 [L,R=301]
########## - END -  www.version of site

walkergv

function listFilesInFolder(folderName) {
  
  var folder = DocsList.getFolder(folderName);
  var contents = folder.getFiles();
  
  var file, data, rows = [];
  
  for (var i = 0; i < contents.length; i++) {
 
    file = contents[i];

walkergv

function createDoc() {
  //
  // Get The Current Spreadsheet
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getActiveSheet();
  //
  // Get data in spreadsheet
  var range = sheet.getDataRange();
  var rowsData = range.getValues();
  //

walkergv

function runReport(profileId) {
  var today = new Date();
  var oneWeekAgo = new Date(today.getTime() - 30 * 24 * 60 * 60 * 1000);

  var startDate = Utilities.formatDate(oneWeekAgo, Session.getScriptTimeZone(),
      'yyyy-MM-dd');
  var endDate = Utilities.formatDate(today, Session.getScriptTimeZone(),
      'yyyy-MM-dd');

  var tableId  = 'ga:' + profileId;