Search results 93

Sorted from new to old.

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

2024Mar14

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

SQL instr

Searching for a string inside a string in SQL. You may say it is the instr in ...

2024Feb3

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

2023Aug7

MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

2023May19

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

DiskDriveType

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

2022Aug17

SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

ToolPath

Returns the path of ThisWorkbook considering OneDrive Personal or Business ...

2021Jan12

1 2 ...5 6