Skip to content

Instantly share code, notes, and snippets.

View pcluddite's full-sized avatar

Tim Baxendale pcluddite

6 followers · 7 following
View GitHub Profile
@pcluddite
pcluddite / SqlHelper.bas
Last active March 7, 2024 02:09
VBA functions for creating SQL statements
'
' SqlHelper
' Copyright (c) 2020 Timothy Baxendale (pcluddite@outlook.com)
'
' This library is free software; you can redistribute it and/or
' modify it under the terms of the GNU Lesser General Public
' License as published by the Free Software Foundation; either
' version 2.1 of the License, or (at your option) any later version.
'
' This library is distributed in the hope that it will be useful,
@pcluddite
pcluddite / gob.bas
Last active January 29, 2024 21:13
From Arrested Development Season 3 Episode 11
PRINT "Gob's program: Y/N?"
INPUT A$
IF UCASE$(A$) <> "Y" THEN END
DO
PRINT "penus ";
LOOP UNTIL INKEY$ = CHR$(27)
@pcluddite
pcluddite / onedrive-duplicates.ps1
Last active February 17, 2024 23:16
Find and recycle duplicate files in onedrive
<#
:
: Copyright 2023-2024 Timothy Baxendale (pcluddite@outlook.com)
:
: Permission is hereby granted, free of charge, to any person obtaining a copy of this software
: and associated documentation files (the "Software"), to deal in the Software without limitation
: in the rights to use, copy, modify, merge, publish, and/ or distribute copies of the Software in
: an educational or personal context, subject to the following conditions:
:
: - The above copyright notice and this permission notice shall be included in all copies or
@pcluddite
pcluddite / restore-menu-win11.ps1
Last active January 29, 2024 22:29
Run this script to restore the old context menu in Windows 11
<#
::
:: Copyright 2024 Timothy Baxendale (pcluddite@outlook.com)
::
:: Permission is hereby granted, free of charge, to any person obtaining a copy of this software
:: and associated documentation files (the "Software"), to deal in the Software without limitation
:: in the rights to use, copy, modify, merge, publish, and/ or distribute copies of the Software in
:: an educational or personal context, subject to the following conditions:
::
:: - The above copyright notice and this permission notice shall be included in all copies or
@pcluddite
pcluddite / Win32File.bas
Last active March 13, 2019 21:12
A set of functions based on the Windows API to manage the file system in VBA
'
' Win32File
' Copyright (c) 2016-2017 Timothy Baxendale (pcluddite@outlook.com)
'
' This library is free software; you can redistribute it and/or
' modify it under the terms of the GNU Lesser General Public
' License as published by the Free Software Foundation; either
' version 2.1 of the License, or (at your option) any later version.
'
' This library is distributed in the hope that it will be useful,
@pcluddite
pcluddite / PowerSheet.bas
Last active November 3, 2019 00:46
Powerful functions for manipulating Excel data utilizing a hidden temporary sheet
'
' PowerSheet
' Copyright (c) 2016-2019 Timothy Baxendale (pcluddite@outlook.com)
'
' This library is free software; you can redistribute it and/or
' modify it under the terms of the GNU Lesser General Public
' License as published by the Free Software Foundation; either
' version 2.1 of the License, or (at your option) any later version.
'
' This library is distributed in the hope that it will be useful,
@pcluddite
pcluddite / SheetEx.bas
Last active March 13, 2019 21:18
VBA module to ease manipulation of sheets and ranges
'
' SheetEx
' Copyright (c) 2016-2017 Timothy Baxendale (pcluddite@outlook.com)
'
' This library is free software; you can redistribute it and/or
' modify it under the terms of the GNU Lesser General Public
' License as published by the Free Software Foundation; either
' version 2.1 of the License, or (at your option) any later version.
'
' This library is distributed in the hope that it will be useful,