Random codes

Random 24 Codes by our developers.

SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

2018Aug16

SQL Join

Different types of join in SQL. A good illustration image i found during my ...

2018Aug31

IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped

2018Apr25

DeleteAllShapes

Delete all shapes in a sheet

2018Jun11

Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

Rename Folder

This will rename and or move a folder

2018Apr18

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

Hiding chart in Excel

How to hide a full chart in Excel. By treating it as shape, not as chart.

2020Dec31

ANBS controls

Set of functions to generate Bootstrap controls as strings. Controls available ...

2018Jun24

Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

2018Sep29

Is64Bit

Determine if system is 64 bit or not. Related to

2020Feb7

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

Error_Raise

To raise a friendly error message with option to show custom error number and ...

2018Jul7

HTMLTagID_Previous

Return id for any html tag that was found above certain location of html page. ...

2024Feb2

Print Button

Simple print button

2018Apr18

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

Open Window

Open another window with java script (_blank) Setting up width, height, ...

2021Mar22

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

2018Jul5

Progress66

Progressbar in light and dark colors, elegant, CSS3 and very neat

2019Feb4

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

DeleteAllFiles

Delete All Files in a Folder. Needs a reference to Microsoft Scripting Runtime

2018Jun30

Shortner

Create a URL shortner using Web.Config AKA URL Redirect, or Page refresher, ...

2019Jan14