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
