Search results 34

Sorted from new to old.

Web.config Redirect

Redirect domain to another, including all its sub pages, sub folders, and ...

2019May21

MouseDown and MouseUp in FM20 controls

MouseDown and MouseUp in VBA (fm20 controls) are different from those in VB6 ...

2019Apr14

VBInstr (or Instr parameters)

The great function InStr I use a lot has a small confusing part. Which string ...

2019Jan9

RunRemote

Runs a macro from another workbook without parameters (WB Workbook has to be ...

2019Jan9

PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

2018Sep23

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

Limit Textarea

Show number of characters in a textarea and limit if it goes greater than ...

2018Jul5

strUnQuote

This will tests to see if strQuotedString is wrapped in quotation marks, and, ...

2018Jul3

DeleteAllFiles

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

2018Jun30

HTMLTag + HTMLPair

Generate HTML tags with thier parameters as name=value pairs ' Example of ...

2018Jun30

ANBS controls

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

2018Jun24

IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

2018Jun18

RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17

Convert2SQLDate

Converts a date (numeric date) into Date acceptable by SQL, as in YYYY-MM-DD ...

2018Jun14

FixPath, IsThere, IsThere1 ...

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

2018Jun11

DownloadFile

Download a file from URL from inside Excel into certain path, returns blank if ...

2018May22

1 2 3