Search results 177

Sorted from new to old.

GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

2018Jun15

ANStrRead + ANStrSave + ANStrSearch

Reads and saves data into 1 dim string array, ANStr ANStr is a string of list ...

2018Jun14

FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

2018Jun11

Modify SQL table

SQL seams to have issues when we try to modify a table and preserving data, I ...

2018Jun9

Frequency

Checks how many items in an ANStr ANStr is list of items separated by a ...

2018Jun8

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

2018May26

GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22

Webapp-ScrollAreas

Allow website to have scroll bars on areas, like a web app Applied in ANmar. ...

2018May19

Calendar, a pure-VBA userform (FrmCal)

VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...

2018May16

SettingRead+SettingSave

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

2018Apr27

FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

InsertHyperlinks+GetHref

Changes all URLs or email addresses in a text into hyperlinks

2018Apr23

No Cache

No cache on client browser

2018Apr23

Str2DB + Str2App + Str2HTML

Set of functions to clean and revise cleaning of string before saving into ...

2018Apr21

ANStrList functions

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

2018Apr14

1 2 ...11 12