Search results 85

Sorted from new to old.

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

Most recent in Oracle DB

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

2020Feb7

IsThere2

Finds a file in giving its full path Similar to IsThere1 except this one uses ...

2020Jan10

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

1 2 ...5 6