Hot answers tagged

3

Comment on Transaction DDL. While Microsoft does state that its presence indicates that the backend supports transactions, there is another reference (possibly outdated) discussing DBPROP_SUPPORTEDTXNDDL enum, where DBPROPVAL_TC_NONE value of Transaction DDL indicates that transactions are not supported. In fact, I have made a few test snippets for ...


2

You do not want to read and write the cell multiple times. You only do a read and a write. You also need to check if the cell has a string. There is no point in running the replace on numbers or errors. Something like: Dim v As Variant Dim i As Long Dim oldLen As Long For Each cell In rng v = cell.Value2 If VarType(v) = vbString Then oldLen =...


1

If Adobe Acrobat DC is available then to convert a PDF file to an Excel .xlsx file use (code in a standard .bas module): Option Explicit Option Private Module '******************************************************************************* 'Save a PDF file as XLSX '******************************************************************************* Public ...


1

I have noticed this interface IDbConnection_CreateCommand, which appears to be an unnecessary coupling between DbCommandBase and DbConnection. DbCommandBase is injected with a DbConnection object: Private Function IDbCommandBase_CreateCommand(ByVal db As IDbConnection, ByVal commandType As ADODB.CommandTypeEnum, ByVal sql As String, ByRef args() As Variant) ...


1

The code breaks at .Applyto with the following error: Run-time error "458" Variable uses an Automation type not supported in Visual Basic. I passed a worksheet range to an Array and this, by definition, creates a 2D array. Here is my testing code. Note: I verified that arr1 gets allocated with the passed Range. Dim arr1() As Variant arr1 = Range(&...


Only top voted, non community-wiki answers of a minimum length are eligible