Search results 147

Sorted from new to old.

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

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

2022Jul3

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

Logging use of executable in Windows

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

2021Jun13

HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

2021Apr16

2 VB.net pdf books

Free from apress website https://www.apress.com More books

2021Mar2

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

BS3 Checks

Check boxes with Bootstrap colors From

2020Oct30

Part of cells in Excel

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

2020Oct13

Bootstrap Editable Table

Editable table with Bootstrap 4, with multiple controls, having: Checkbox for ...

2020Oct6

1 2 ...5 ...9 10