Output Parameter in Excel VBA

Hot Topic

MS Office document and image writer print driver
Place a CR in normal Text Box via vba
dtpicker MicrosoftWord Template
Visual Basic for Excel
excel formula
Sort table based on array
Control Break Trap will not work whilst Userform is displayed
Executing code off of a cell update
Change format of cells
Trouble while dealing with Share Point Object Model

Microsoft ISV

Need direction on using code instead of VLOOKUP
Access 2000 RecordSet Sort problem
Need help writting a script similar to...
DLookup help?
MS Office document and image writer print driver & port
Supplying variables for a stored procedure through a form
OK Trying Again - A Simple Very Simple Routine
worksheet_change and data validation
uploading Data from excel to a InSQL Server
sending emails from MS Word with variable subject line

Output Parameter in Excel VBA

Hi,

I am using Sybase Database. There is a stored proc having an output parameter. I need to write a macro to execute the proc and retrieve the output value. I know how to create a connection, but I dont know how to execute the proc.

Kindly help

Subhojeet




Answer this question

Output Parameter in Excel VBA

  • Marcus J

    You ned to use the AxtiveX Data Object(ADO) model.

    Use the Command object which allows you to use the 'execute' method after passing items to the 'paramters' field.

    See the Code Librarian on the Office Developers edition for plenty code example. Come back if you don't have access.

    Robert, Edinburgh



  • Output Parameter in Excel VBA
Answer this question