Photo Gallery Member List Search Calendars FAQ Ticket List Log Out


Passing vbscript arrays to VB COM object

 
Logged in as: Guest
arrSession:exec spGetSession 2,2,3599
 Active Users: There are 0 members and 0 guests.
 Users viewing this topic: none
 

 

 
  
  Printable Version
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Passing vbscript arrays to VB COM object
  Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!
Page: [1]
Login
Message << Older Topic   Newer Topic >>
 Passing vbscript arrays to VB COM object - 6/30/2005 10:19:51 PM   
  jbatty

 

Posts: 4
Score: 0
Joined: 6/21/2005
From:
Status: offline
My COM object has the following signature

      
I have created an instance of the object and i am trying to pass the 2 arrays from within a VBScript

      

i.e.
      
however I am getting the TYPE MISMATCH error

Can anyone please advise
 
 
Post #: 1
 
 Re: Passing vbscript arrays to VB COM object - 7/1/2005 7:28:46 AM   
  ehvbs

 

Posts: 2220
Score: 50
Joined: 6/22/2005
From: Germany
Status: offline
Possibly this VBA code

      
shows you, that to call "myValue = myfunction(timeA, rateA)" you must change the
signature to "Function myfunction(time As Variant, rate As Variant) As Variant".
If you can't do that, try to call your function like this:

      
This I didn't test, so expect it to fail.

(in reply to jbatty)
 
 
Post #: 2
 
 
 
  

If you found our site useful please link to us <a href="http://www.visualbasicscript.com">VisualBasicScript.com</a>.
All Forums >> [Scripting] >> WSH & Client Side VBScript >> Passing vbscript arrays to VB COM object Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts