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
Related Tags
vba × 1207excel × 831
performance × 248
beginner × 78
object-oriented × 78
array × 48
ms-access × 43
error-handling × 34
web-scraping × 33
ms-word × 28
sql × 26
strings × 25
time-limit-exceeded × 23
vb6 × 23
algorithm × 21
rubberduck × 20
datetime × 19
sorting × 17
file-system × 17
unit-testing × 16
collections × 15
adodb × 15
hash-map × 14
design-patterns × 12
game × 10