Search results 113

Sorted from new to old.

SQL Cross Apply String_Split with XML Path

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

2024Jan20

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Send page to print

JavaSctipt commnad to show Print dialog when a page is visited. I usually put ...

2023Aug11

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

MapPath_SafeComma

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

2023May19

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

Windows Common Controls 6.0

This is the needed library to have Windows Common Controls installed to be used ...

2023Feb19

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

iframeBtn

A button in iframe, to run certain command and return status to end user ...

2022May14

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

OpenAnyFile

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

2022Jan28

1 2 ...7 8