Byref Argument Type Mismatch

[Guest]

I get the "Byref Argument Type Mismatch" error when I try to pass 2 arguments
from VBA module-1 to module-2 using the below code: When I modify the code
to only accept 1 argument it works but i'd like to pass both.

thanks Alex

module-1
ProjSnap strSelected, SQLText
module-2
Public Sub ProjSnap(strSelected As String, SQLText As String)

 

[Dirk Goldgar]

I get the "Byref Argument Type Mismatch" error when I try to pass 2
arguments from VBA module-1 to module-2 using the below code: When I
modify the code to only accept 1 argument it works but i'd like to
pass both.

thanks Alex

module-1
ProjSnap strSelected, SQLText
module-2
Public Sub ProjSnap(strSelected As String, SQLText As String)

What are the definitions of strSelected and SQLText?

 

[Guest]

I was missing the parens around the arguments, I got it to work

thanks

Alex