Search results 35

Sorted from new to old.

MinIF and MaxIF in Excel 2010

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

2019Feb1

Num2Ar

Convert numbers into Arabic words, like 230 to مائتان وثلاثون I have multiple ...

2019Jan9

User-Defined Formatting

Apply special Conditional Formatting, color cells based on their values. This ...

2019Jan9

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

2018Nov25

ImagesIn

Just like FilesIn function, but this one returns list of images only found in a ...

2018Nov24

SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

SetAttr

Sets an attribute to file or folder Needs to have variables defined as you see ...

2018Aug16

ExportSheets_to_1PDF

Export multiple sheets as pages in 1 pdf doc. Passing list of sheets as ...

2018Aug8

MSSQL DB Connection

Connects to MSSQL database from Classic ASP All DB variables need to be ...

2018Jul29

MySQL DB connection

Connects to MySQL database from Classic ASP All DB variables need to be ...

2018Jul29

UnBreakAr + BreakAr

Fix broken Arabic char, by using AscW and ChrW This is Excel User-defined ...

2018Jul25

LogFile_Add

Adds an entry to log file, if file is not exist, it will be created. Filename ...

2018Jul17

BinaryFile_Read + BinaryFile_Save

Reads binary file in chunks, if not chuck defined, all file will be red/saved ...

2018Jun18

BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16

FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7

1 2 3