Skip to content

Instantly share code, notes, and snippets.

View blonkm's full-sized avatar

Michiel van der Blonk blonkm

View GitHub Profile
@blonkm
blonkm / SchoologyGetLatestSubmissions
Last active August 29, 2015 14:22
Get only last revision from a Schoology submissions download
# (c) Michiel van der Blonk
# blonkm@gmail.com
# @name SchoologyGetLatestSubmissions.ps1
# @date 2015-06-12
# @description Get only last revision from a Schoology submissions download
# @notes copies files to a new folder on the destination named schoology_<date>
# @args
# path defaults to current directory
# destination defaults to desktop
@blonkm
blonkm / modSQL.bas
Created October 2, 2015 19:37
Generate SQL using Excel VBA
'---------------------------------------------------------------------------------------
' Module : modSQL
' Author : Michiel van der Blonk (blonkm@gmail.com)
' Date : 10/1/2015
' Purpose : generate SQL queries from Excel cell data
'---------------------------------------------------------------------------------------
Option Explicit
Enum eEscape
@blonkm
blonkm / convert2.ps1
Last active May 4, 2024 18:11
Convert all files in a folder from XLSX to CSV or from CSV to XSLX
# May 4, 2024
# convert all files in a folder from xlsx to csv or the other way around
# run like ".\convert2.ps1 xlsx csv" or ".\convert2.ps1 csv xlsx"
param (
[string]$src,
[string]$dst
)
$excel = New-Object -ComObject excel.application