Skip to content

Instantly share code, notes, and snippets.

View larsschenk's full-sized avatar
💭
Working on ActiveBarcode

Lars Schenk larsschenk

💭
Working on ActiveBarcode
View GitHub Profile
@larsschenk
larsschenk / Excel-ActiveBarcode-Access.vba
Last active April 12, 2017 10:53
Access ActiveBarcode objects from Excel
' Avoid using ActiveSheet in your scripts
' if you are not sure if the active sheet remains active while
' running your VBA script.
' Best practise is to access the ActiveBarcode object via a variable
' That is stored for the whole livecycle of your script.
' Access the ActiveBarcode object without using ActiveSheet is
' shown here:
Public Sub AccessBarcode()
Dim MyBarcode ' Variable to access the barcode
' Change the name of the worksheet and the name of the barcode object if required:
@larsschenk
larsschenk / Get_Variable_Type.vba
Created February 1, 2017 00:04
Get variable type in VBA
' Helper function
Private Function Get_Variable_Type(myVar)
If VarType(myVar) = vbNull Then
MsgBox "Null (no valid data) "
ElseIf VarType(myVar) = vbInteger Then
MsgBox "Integer "
ElseIf VarType(myVar) = vbLong Then
MsgBox "Long integer "
ElseIf VarType(myVar) = vbSingle Then
MsgBox "Single-precision floating-point number "

Keybase proof

I hereby claim:

  • I am larsschenk on github.
  • I am lschenk (https://keybase.io/lschenk) on keybase.
  • I have a public key whose fingerprint is 14BE 22B6 E6F7 8C4E 5A85 03DE 4F05 D09A 0B73 293B

To claim this, I am signing this object:

@larsschenk
larsschenk / csharp-in-powershell.ps1
Last active December 11, 2016 19:37
C# in powershell
##########
# C# code
$Source = @'
using System;
using System.Runtime.InteropServices;
using System.Drawing;
using System.Drawing.Imaging;
namespace ActiveBarcode.Tool
{
@larsschenk
larsschenk / Create_Barcodes.vba
Last active October 13, 2016 21:09
Create Barcodes from an Excel List with www.ActiveBarcode.com
Public Sub Create_Barcodes()
' Copyright (c) by Schenk & Horn, www.activebarcode.com, www.activebarcode.de
ScreenUpdating = False
' Column the data is stored
DataColumn = "B"
' Number of Row the data begins
DataRow = 1
' Number of Column the barcodes shall be placed
BarcodeColumn = "A"
@larsschenk
larsschenk / ad_pub_head.php
Last active October 12, 2016 21:33
WoSp ad_pub_head.php
<?php
// OMS/Google Anzeige Script
// 2 Datei, ad_pub_head.php und ad_pub_body.php
//
// Einstellung:
//
// Kampagne Einstellung von OMS/Google
// var oms_site = 'oms.wochenspiegel-online.de';
// var oms_zone = 'test';
# Baylys Kiteboarding Child
Just a simple start for a WordPress child theme for keyboarding based on baylys.
This file should give the gist a meaningfull title, only ;-)
@larsschenk
larsschenk / baylys-leible-child.css
Last active July 16, 2016 13:25
Wordpress Theme: Baylys Leible Child
/* Let the style.css empty by design and use this css instead.
This way we can work around the cache by increasing version numbers.
*/
#header {
background:#1F2D52 !important;
max-width: 100%;
}
#footer {
background:#1F2D52 !important;
<?php
/**
* Plugin Name: Disable NewRelic at AMP
* Description: Removes NewRelic script code from AMP pages
* Plugin URI: http://www.lars-schenk.com/
* Version: 0.0.2
* Author: Lars Schenk
* Author URI: http://www.lars-schenk.com
* Licence: MIT
* License URI: http://opensource.org/licenses/MIT
@larsschenk
larsschenk / BarcodeImage-Demo.bat
Created December 14, 2015 22:15
ActiveBarcode BarcodeImage-Demo.bat
@ECHO OFF
REM ### barcodeimage-demo.bat
REM ###
REM ### Simple script to create demo_barcode_image* files for
REM ### demonstration purpose using the
REM ### ActiveBarcode commandline tool "barcodeimage.wsf"
REM ###
REM ### By Schenk & Horn, www.activebarcode.de & www.activbarcode.com
REM ### You are allowed to use and modify this script (barcodeimage-demo.bat)
REM ### in any way you want. Check out the website for full documentation.