Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Microsoft ISV Community Center Forums >> Visual Basic for Applications (VBA)

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

[283 byte] By [Subhojeet] at [2007-12-24]
«« Can a Connection Manager be parameterized?
»» Significant slowdown in a Windows service from .NET 1.0 to .NET 2.0
# 1

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

Microhands at 2007-8-31 > top of Msdn Tech,Microsoft ISV Community Center Forums,Visual Basic for Applications (VBA)...
Microsoft ISV Community Center Forums
Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified