ByRef type Mismatch error

[sweetleaf]

Hi there,

I am calling a public sub that resides in a VB project which expects several inputs og string and variant type.

I am passing from an ms excel project and I am passing the right data type (string) and yet I get a "ByRef type mismatch error" - does anyone know why this is?

Thanks!

 

[JohnYingling]

Show the Call, with Dims, and the called Procedure statement. Remember...No AS clause is the same as AS VARIANT.

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[JohnYingling]

Another possibility.
Dim A, B, C As String
is equivalent to
Dim A As Variant, B As Variant, C As String

http://www.VBResizer.com

Generate Forms/Controls Resizing/Tabbing Class

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[sweetleaf]

Thanks John,

I worked it out - the problem actually stemmed from not being able to create the object from my calling xsub.
It's fixed now though - thank you!