Search results 60

Sorted from new to old.

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

CutString11

Cuts long string from certain character to certain character with option to ...

2024Feb24

Install/Uninstall SQLNativeClient DB driver

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

2024Feb8

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

SqlExec

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

2023Sep3

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

DB connection driver

What is the Driver part in ConnectionString

2023Jun2

NavigatePost

Reads content of webpage with optional post data two main differences from

2023Jan14

DBTables

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

2022Apr28

DB_Connect_Install

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

2020Mar24

DB_Connect

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

2020Mar20

List of Databases

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

2019Oct6

DB_ExtendedProperties

Returns extended properties of a database, knowing the ADODB connection

2019Jul22

DBMySQLVBA API

An API to allow connecting to MySQL database from VBA (or VB6), found it a ...

2019Feb3

1 2 3 4