Vb Script for Excel

[Guest_imported]

Hi,
If i want to get a variable from a stored procedure in sql and place that variable in cell A1, what is the code in Vb Script to do that?

So if the variable name is called Case_ID in my SQL stored procedure and i want to place it in cell A1, how do i iopen the stored procedure then call for the variable case_Id and aassign it to that cell?

thanks

 

[FengShui1998]

Soultion,


Set objXL = WScript.CreateObject("EXCEL.application&quot
objXL.Visible = True
objXL.WorkBooks.Add

Set wks = objXL.Worksheets
wks.add.Name = "Project"

Set Actv = objXL.Worksheets("Project&quot
Actv.Range("A1&quot.Value = case_id

fengshui_1998