Closes a workbook, checks if it is already open first, works for workbooks ...
2018Aug9
Returns cleaned file name of invalid characters. Needs to be modified if used ...
2023Jan11
Generate HTML tags with thier parameters as name=value pairs ' Example of ...
2018Jun30
Checks if LocIndex is found between open and close of HTMLTag or between close ...
Feb28
Returns the full string starting from open tag of container where LocationIndex ...
Apr3
Reads content of Page from URL to a sheet. This was made specially for certain ...
2023Apr4
Reads string between open and close HTML tag (between < ... > and < / ... >), ...
2020Aug15
Counts how many cells matching 2 criterias.
Just like
Wed 7AM
Listing the file from a folder that was created during last few hours. Can ...
Tue 7AM
Finds the location of a sting inside list of strings with certain separator, or ...
Apr23
An API to allow connecting to MySQL database from VBA (or VB6), found it a ...
2019Feb3
Read shapes in all worksheets in certain workbook and return list of macros ...
2018Jul9
Calculate distance between two points (Latitude, Longitude) LatLon1 and ...
2018Jun27