Codes Required

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr3

Card image cap
Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

Mar23

Card image cap
FindAncherURL_InHTMLRow

Finds the URL (href tag value) for an anchor inside a table row (tr element) ...

Mar4

Card image cap
HTML_InsideTag_ByIndex

Checks if LocIndex is found between open and close of HTMLTag or between close ...

Feb28

Card image cap
CutString_ReverseFrom

Returns full string starting from the point of LocIndex minus back where we ...

Feb27

Card image cap
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Dec19

Card image cap
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

Dec17

Card image cap
VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

Dec3

Card image cap
IntlIsAlphaCharacter

Test if a character is alphanumeric, regardless of the code page or language ...

2020Mar21

Card image cap
CutString3

Cuts a string from a larger one using separators.
Ex, CutString3("Will ...

2018May29

Card image cap
Hex2Bin

Converts Hex to Binary

2018May28

Card image cap
NameSilo_APICall_ListPrices

Downloads list of domains and prices for register, renew or transfer into ...

2018May25

Card image cap
NameSilo_APICall_ListDomains

Downloads list of registered Domains in your account from NameSilo.com using ...

2018May25

Card image cap
NameSilo_APICall_AvailableBalance

Gets your balance in your NameSilo account using your own API

2018May23

Card image cap
GoToInternet

Opens webpage from within Excel, using default browser

2018May22

Card image cap
InsertHyperlinks + GetHref

Converts https found in text into anchers < a > Comes with GetHref as bonus ...

2018May13

Card image cap
SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27

Card image cap
DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...

2018Apr14

Similar codes

Card image cap
O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

Jul10

Card image cap
Open Window

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

2021Mar22

Card image cap
Language per app

Restore Windows 10 setting to remember language selected per application

2019Jan9

Card image cap
Window and screen sizes in jQuery

Get the size of the screen, current web page and browser window using jQuery ...

2021Mar18

Card image cap
Temporary folder in Win10

Where is the Temp folder in Windows 10? Since Windows 7, it has been in the ...

2019Apr9

Card image cap
LogoutALL

Logs out Linkedin by running two commands One will open new window to logout ...

2018Apr23

Card image cap
Windows Clock

Restore Windows 10 clock to Windows 7 Analog clocks

2019Jun28

Card image cap
Excel recovered files

Location of Excel recovery workbooks in your system when Excel crashes, it ...

2023Mar31

Card image cap
Multiple sizes blog Card

Blog post card in multiple sizes and responsive using Bootstrap 3

2019Feb2

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Tue 7AM

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
AN_SafeFileName

Clean filename from special characters to make it safe for server upload Then ...

2019Dec10

Card image cap
LastInsertedID_SQL

Get the ID of the last inserted record in a table. There are other methods, ...

2019Jul18

Card image cap
FormulasFlatten

Fill in formulas from 1st row, then convert them to flat values to avoid Excel ...

2018Jun30

Card image cap
Navigate

Downloads a certain page source into a variable, full content in HTML, using ...

2018May22