Search results 132

Sorted from new to old.

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

SaveAsHTML_Template

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

2022Feb5

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

COUNTIFS as Rank

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

2022Jan1

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

2021Jun9

EnvironList

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

2021Jan12

Modify volume using nircmd

Batch file to lower volume of computer system (using nircmd.exe).

2021Jan1

Save Excel range (or shape) to picture

This is an interesting approach to export a range of cells into picture using ...

2020Dec21

Input text - pre-Placeholder

Remove text when textbox is selected, then put it back if it left empty This ...

2020Oct10

Responsive JS Tags

Responsive Tags Input With Autocomplete Examples using Bootstrap 4 Originally ...

2020Oct9

1 2 3 ...8 9