VBA references question

[ShamonMF]

i have a macro that creates an ADO connnection object & manipulates the recordset within the macro in excel.

i wish to use the vba code to create a standalone .vbs file to run on a desktop.

In order for the code to work I have to reference the latest Active X library (for me 2.8), if not the code breaks.

When i stick the code in and run it from a vbs file it breaks in the same way, but i dont know how to make it reference the appropriate library from within a vbs.

I have NO experience of VB script, but some excel vba. Is there something I am missing here?
Cheers for any input you can offer

 

[Colin Legg]

Hi,

You would have to use late binding. Why have you decided to use VB Script?

 

[Fazza]

Hi Shamon,

one example - there are many if you search - of late bound ADO http://www.mrexcel.com/forum/showthread.php?t=340914

HTH, F

 

[westconn1]

no references in vbs,
also do not specify any type for declared variables
most of the vbs code will run in vba ide, apart from things like wscript.echo

 

[ShamonMF]

cheers guys.

The intention initially was to avoid any user actions affecting the results that are copied into the sheet at the end of the routine.