Search results 17

Sorted from new to old.

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

Control the Panel

A set of commands (or shortcuts) allowing users to access Control panel items ...

2019May19

IsBin

Checks if the passed argument is a binary or not

2018Oct16

PrettyPath

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

2018Sep23

PCase

Converts a string into proper case PCase or ProperCase since Classic ASP does ...

2018Sep7

Upload4

Uploading files into server, the simplest way I have here This is the famous ...

2018Sep2

PCase (ProperCase)

Just like UCase and LCase, ProperCase (or PCase) will capitalize 1st letter of ...

2018Aug8

CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

2018Jul14

Limit Textarea

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

2018Jul5

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

1 2