Search results 88

Sorted from new to old.

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

File_SettingRead + File_SettingSave

Reads and saves settings to Settings file, used asp here. Similar to

2022Dec27

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

ASP to static HTML

Convert Dynamic ASP files into HTML (once daily) to make them faster when ...

2020Dec24

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

Part of cells in Excel

How to modify part of text inside an Excel cell using VBA. Something in my ...

2020Oct13

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

ReadHTMLTag

Reads string between open and close HTML tag (between < ... > and < / ... >), ...

2020Aug15

SortedFiles

Get a sorted list of files in a directory using the File System Object (FSO) ...

2020Aug11

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

Window off-screen

Window not shown while taskbar says it is on. Restore window position in ...

2020Mar17

1 2 ...5 6