Skip to content

Instantly share code, notes, and snippets.

View sancarn's full-sized avatar

Sancarn sancarn

143 followers · 33 following
View GitHub Profile
@sancarn
sancarn / test.md
Last active July 5, 2019 11:34
VBA Pointers and SizeOf() 
  Dim x01 As Boolean
  Dim x02 As Byte
  Dim x03 As Currency
  Dim x04 As Date
  Dim x05 As Double
  Dim x06 As Integer
  Dim x07 As Long
  Dim x08 As LongPtr
  Dim x09 As MsoRGBType
@sancarn
sancarn / README.MD
Created June 3, 2019 10:08
Subclassing Excel
@sancarn
sancarn / A_.ahk
Last active August 19, 2024 19:40
class A_ {
class COM {
GetActiveObject(){
}
GetActiveObjects(){
}
class _COMObject {
__New(obj){
@sancarn
sancarn / Modelling in Excel.yaml
Created December 8, 2018 16:37
GIS Embedded in Excel - Shared with Script Lab
name: Modelling in Excel
description: GIS Embedded in Excel
author: sancarn
host: EXCEL
api_set: {}
script:
content: |-
MakeMap()
var data = {}
@sancarn
sancarn / VbaJsBridge.yaml
Created December 8, 2018 16:36
Shared with Script Lab
name: VbaJsBridge
description: ''
author: sancarn
host: EXCEL
api_set: {}
script:
content: |-
//Initialise VbaJsBridge
VbaJsBridge_Initiate();
var Timer: Number = 1000;
@sancarn
sancarn / Code for Claudio.vb
Last active July 13, 2021 17:53
Public HeaderColor as Long
Private OptionsSheet as Worksheet
Private DataSheet as Worksheet
Private Sub Worksheet_Change(ByVal Target As Range)
Me.HeaderColor = RGB(217, 217, 217)
set OptionsSheet = sheets("Options")
set DataSheet = ActiveWorksheet
if target.address = "$B$1" then
@sancarn
sancarn / .Object.query.md
Last active October 16, 2018 23:51
Query javascript objects for a specific structure

Object::query()

Say you have some object:

var data = [
  {
    type:"Person",
    name: "Suzanne",
    pets:[
@sancarn
sancarn / Idea.md
Last active September 16, 2018 03:46
Ruby hash/type parser for javascript

Simplify _getList and _getKeyValues

function measureDepth(depth,index,sectionString){
  switch(sectionString[index]){
      case "{":
        depth["{}"]++;
        break;
      case "}":
 depth["{}"]--;
@sancarn
sancarn / non worker js.html
Created September 9, 2018 10:03
<!DOCTYPE html>
<html>
<head>
<script src="/libraries/jQuery.js"></script>
<script src="/libraries/Ace/build/ace.js"></script>
<script src="console.js"></script>
<link rel="stylesheet" href="console.css" type="text/css" />
<style>
html, body{
@sancarn
sancarn / Pile.rb
Last active August 30, 2018 15:27
Piles are a great way of updating all values of a set at once, instead of mapping arrays constantly.
=begin
Piles are a great way of updating all values of a set at once, instead of mapping arrays constantly.
E.G.
Example CSV:
a,b,c
1,2,3
4,5,6
Then:
csv=CSV.new(text, {:headers=>true})