Dear everyone,
I need to use the ADO component for SQL data processing. The normal way is to statically tick the ms ado reference in the VBE-Reference window.
But to make this code modular, is there anyway to dynamically call the msado15.dll reference in the scripting?
I checked that in MS excel that it can be done, as seen in the following link. But I didn't make it working in FTview.
http://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically-vba-excel
Appreciate if anyone can guide me through it.
Chao
I need to use the ADO component for SQL data processing. The normal way is to statically tick the ms ado reference in the VBE-Reference window.
But to make this code modular, is there anyway to dynamically call the msado15.dll reference in the scripting?
I checked that in MS excel that it can be done, as seen in the following link. But I didn't make it working in FTview.
http://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically-vba-excel
Appreciate if anyone can guide me through it.
Chao