MinIF and MaxIF in Excel 2010

MinIF to calculate smallest number matching certain criteria, in Excel 2010 ...

MaxIF_MinIF_byNMR.zip

INITool

INITool Object allows an ASP programmer to work with INI files on the server. ...

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

Unzip_7Zip

Extracts a zip into a location and waits for that extraction to finish Using ...

Resources.zip

MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

Page area and Page Setup functions (Unfinished)

Clear Excel print area, or set it, or read it, along with Page setup commands ...

BrowseWorkbook + BrowseWorkbook_Save

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

VBA Progressbar (Frm73)

Progress bar Frm73 or just simple message Zip file contains .frm and .frx ...

Frm73.zip

DB_Read1Row (DB_Read1stRow)

Reads from a table in a DB Reads only the first row, and return a string ...