On 2016-09-20 03:56, Alan Bourke wrote:
Well in terms of the named parameters don't you just need to use positional parameters in the Add() instead?
loListObject = loSheet.ListObjects.Add(0, "ODBC:" ... )
Or maybe I can create a template file with the macro embedded, and call the macro, passing the parameters it needs so it can keep it's VBA style?