Search results 33

Sorted from new to old.

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

DB_Setting1List + DB_Setting1List_NameValue

DB_Setting1List is to Returns list of SettingValues matching certain ...

2018May31

FileDate_Formatted

Returns a formatted version of file 'LastModified' date. Pass parameter ...

2018Apr25

1 2 3