Random codes

Similar codes

DB_Connect_Install

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

2020Mar24

ANmarAmdeen

Records Affected by Execute command

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

2018Sep1

ANmarAmdeen

DB_Connect

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

2020Mar20

ANmarAmdeen

DBTables

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

2022Apr28

ANmarAmdeen

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

ANmarAmdeen

Connect to UDL

Use a UDL to make your connection to a database

2018May27

JeffSmith

Install/Uninstall SQLNativeClient DB driver

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

Feb8

ANmarAmdeen

List of Databases

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

2019Oct6

ANmarAmdeen

DB_Setting2Read + DB_Setting2Save

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

2018May31

ANmarAmdeen

Recently by developer

MatchIF5

Searching for rows having 5 values in 5 columns Like

Mon 5PM

ANmarAmdeen

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

ANmarAmdeen

Files_FoundHours

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

Apr30

ANmarAmdeen

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

ANmarAmdeen

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

Oct17

ANmarAmdeen

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

ANmarAmdeen

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

ANmarAmdeen

FormatPhoneNumber

Formats a given 10 digit number into a nice looking phone number

2019Jan5

ANmarAmdeen