I am using the code from Microsoft to pull my procedure name in VBA, but I would like to add the function to pull back the parameters also. I cannot figure out what need to be added to it.
http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx
Sample output:![]()
Please Login or Register to view this content.
DATAWHSE: openconnection2
DATAWHSE: GetUser
DATAWHSE: GetAnalyst
DATAWHSE: GetDemand
DATAWHSE: GetQOH
DATAWHSE: GetOfm
Sample of Module Code:
Function GetDemand(Line, Item) As Double
What I would like to see outputted:
DATAWHSE: GetDemand ;Line, Item
Any and all assistance is appreciated.
Bookmarks