atifaziz

# Copyright (c) 2014 Atif Aziz. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,

atifaziz

Sub DisableBackgroundRefreshOnAllWebQueries()

    Dim Worksheet  As Worksheet
    For Each Worksheet In ActiveWorkbook.Worksheets
        Dim QueryTable As QueryTable
        For Each QueryTable In Worksheet.QueryTables
            If 0 = StrComp(Left(QueryTable.Connection, 4), "URL;", vbTextCompare) _
               And QueryTable.BackgroundQuery Then
                Debug.Print QueryTable.Connection
                QueryTable.BackgroundQuery = False

atifaziz

// http://msdn.microsoft.com/en-us/library/system.threading.tasks.task.whenall.aspx

using System;
using System.Threading;
using System.Threading.Tasks;

static class TaskExtensions
{
    public static Task<T[]> WhenAll<T>(this Task<T>[] tasks)
    {

atifaziz

Add-Type -AssemblyName System.Security;
[Text.Encoding]::ASCII.GetString([Security.Cryptography.ProtectedData]::Unprotect([Convert]::FromBase64String((type -raw (Join-Path $env:USERPROFILE foobar))), $null, 'CurrentUser'))

atifaziz

'==========================================================================
' JSON Encoder for VBScript
' Copyright (c) 2013 Atif Aziz. All rights reserved.
'
' Licensed under the Apache License, Version 2.0 (the "License");
' you may not use this file except in compliance with the License.
' You may obtain a copy of the License at
'
'    http://www.apache.org/licenses/LICENSE-2.0
'

atifaziz

// http://channel9.msdn.com/Events/Build/2013/2-401
// http://www.quaetrix.com/Build2013.html

using System;

// For 2013 Microsoft Build Conference attendees
// June 25-28, 2013
// San Francisco, CA
//
// This is source for a C# console application.

atifaziz

Function PrettyXML(ByVal Source, Optional ByVal EmitXMLDeclaration As Boolean) As String

    Dim Writer As MXXMLWriter, Reader As SAXXMLReader
    Set Writer = New MXXMLWriter
    Writer.indent = True
    Writer.omitXMLDeclaration = Not EmitXMLDeclaration
    Set Reader = New SAXXMLReader
    Set Reader.contentHandler = Writer
    Reader.Parse Source
    PrettyXML = Writer.Output

atifaziz

# Copyright (c) 2014 Atif Aziz. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,

atifaziz

# Copyright (c) 2014 Atif Aziz. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#    http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,

atifaziz

[alias]
	aliases = config --get-regexp ^alias\\.
	last = log -1 HEAD
	ls = log --decorate --pretty=format:%Cgreen%h%Cred%d%Creset\\ %s\\ [%an]
	ll = log --pretty=fuller
	st = status
	diffc = diff --cached
	ci = commit
	cia = commit --amend
	mff = merge --ff-only