Similar codes

Card image cap
DB_Connect_Install

Connects to SQL DB using ADODB, if driver not installed, it will attempt to ...

2020Mar24

Card image cap
Records Affected by Execute command

Records affected by sql Execute command https://docs.microsoft. ...

2018Sep1

Card image cap
DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...

2020Mar20

Card image cap
DBTables

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

2022Apr28

Card image cap
DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

Card image cap
Connect to UDL

Use a UDL to make your connection to a database

2018May27

Card image cap
Install/Uninstall SQLNativeClient DB driver

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

Feb8

Card image cap
List of Databases

Script to list databases available in a server using ADODB connection From

2019Oct6

Card image cap
DB_Setting2Read + DB_Setting2Save

Reads and save setting into settings table per 2 IDs, similar to SettingRead ...

2018May31

Recently by developer

Card image cap
ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table.

Thu 3PM

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Random Codes

Card image cap
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18

Card image cap
Send To folder

Where can I find the SendTo folder? I always wanted to modify that list and ...

2019May15

Card image cap
GetFilename, GetExtension, .. others

GetFilename, GetExtension, GetFilename_noExtension, GetFilename_wExtension To ...

2018Jun11

Card image cap
FrmPass

Prompt for a password, or username and password, returns information back to ...

2018May20