A one user ask about Creating XLS file with ADO.
This was interesting to me so I use uncle google and find this:
https://forums.autodesk.com/t5/visual-basic-customization/ado-connection-create-file-excel/td-p/1675928
EDIT: https://msdn.microsoft.com/en-us/library/ms675849(v=vs.85).aspx
How you can read in this mentioned above link, This is not posible with ADO but quite easy with ADOX.
Here is AutoIt example:
;~ https://forums.autodesk.com/t5