Pulling data from ALM to Excel -

i'm trying pull data alm , save in excel sheet. i'm writing code in workflow of alm. when write below single , tried save, throwing error:

dim cn adodb.connection

do have give references before writing code? if how give reference?

it's vbscript, not visual basic.

do not give type when declaring variables :

write

  dim cn 

instead of

  dim cn whatever 

also, if want run queries on alm database workflow scripts, can use tdconnection.command, if administrator did not restrict use.