Anders Eriksson wrote ...

Hello Ron,
1) I'm using your ADO functions and as a param to GetData you have
SourceRange, how do I specify the range if I want it to be all data in the
sheet?

Looks like the SourceRange argument can be a zero length string. Being
optional would be more explicit, it could be omitted e.g.

Public Sub GetData( _
ByVal SourceFile As Variant, _
ByVal TargetRange As Excel.Range, _
ByVal SourceSheet As String, _
Optional ByVal SourceRange As String, _
Optional ByVal HeaderRow As Boolean = True _
)

End Sub

--