Search results 178

Sorted from new to old.

WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

2018Jun16

WaitFor + ShellWait

Tell App to wait for number of seconds and Execute command and wait for it ...

2018Jun16

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

RemoveHTML

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

2018May26

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

1 2 ...11 12