Skip to content

Instantly share code, notes, and snippets.

@bash0C7
bash0C7 / dsrsh.rb
Created January 9, 2012 13:43
Redmine Client Ruby REPL
# -*- coding: utf-8 -*-
abort if ARGV.empty?
initializer = ARGV.shift
eval(File.read(initializer), binding)
prompt_prefix = File.basename(initializer)
require 'rubygems'
require 'pry'
pry(prompt_prefix)
@bash0C7
bash0C7 / gist:1548791
Created January 2, 2012 00:28
num↔hex functions
Public Function convNUMtoHEX(Number As Long) As String
convNUMtoHEX = CStr(Hex(Number))
End Function
Public Function convHEXtoNUM(HexString As String) As Long
Const HEXMARK = "&H"
Const UNSIGN = "&"
convHEXtoNUM = Val(HEXMARK & HexString & UNSIGN)
End Function
@bash0C7
bash0C7 / gist:1548764
Created January 2, 2012 00:20
ExcelDataRecord.cls
Option Explicit
Private MainKeyCol As Long
Private RowCounter As Long
Private Source As Workbook
Private isReadOnly As Boolean
Property Get EOF() As Boolean
@bash0C7
bash0C7 / WorkLogger.vbs
Created January 2, 2012 00:15
WorkLogger.vbs
'1 line ver
CreateObject("Scripting.FileSystemObject").OpenTextFile(CreateObject("Scripting.FileSystemObject").BuildPath(CreateObject("Scripting.FileSystemObject").GetParentFolderName(WScript.ScriptFullName), "worklog_" & WScript.CreateObject("WScript.Network").ComputerName & ".txt"), 8, True).WriteLine date & vbtab & time & vbTab & InputBox("Comment", WScript.ScriptName)
'3 line ver
With CreateObject("Scripting.FileSystemObject")
.OpenTextFile(.BuildPath(.GetParentFolderName(WScript.ScriptFullName), "worklog_" & WScript.CreateObject("WScript.Network").ComputerName & ".txt"), 8, True).WriteLine date & vbtab & time & vbTab & InputBox("Comment", WScript.ScriptName)
End With
'4 line (basic)
With CreateObject("Scripting.FileSystemObject")