Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

unpcaking a safe array

Status
Not open for further replies.
Jevakil

Jevakil

Mechanical
Joined
Mar 19, 2003
Messages
41
Location
US
I have a VARIANT of type SafeArray containing three longs. I have a varaibale m_Data (3) of type Long. How can I pass the data from Variant to m_Data.

Dim m_Var As Variant
Dim m_Data (3) As Long

How do you put the m_Var data into m_Data in VB?.



jevakil@mapdi.com

One nuclear bomb can ruin your whole day.
 
Sort by date Sort by votes
Code: 
Dim i As Integer
For i = LBound(m_Var) to UBound(m_Var)
    m_Data(i) = m_Var(i)
Next i

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.
 
Upvote 0 Downvote
Thank you dsi. It worked.

jevakil@mapdi.com

One nuclear bomb can ruin your whole day.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JoelTXCive
  • Locked
  • Question Question
Sending an Array into an Excel VBA function and Also Getting an Array Out
Replies
6
Views
1K
IDS
IDS
blackeng1660
  • Locked
  • Question Question
Error macro which multiple coincidence assemblies fastly
Replies
0
Views
887
blackeng1660
blackeng1660
rotw
  • Locked
  • Question Question
Sending Visual Basic Output Window (Program Output) to a Form (Text Box) or File
Replies
11
Views
2K
rotw
rotw
SBaugh
  • Locked
  • Question Question
VBA Automation tools
Replies
3
Views
1K
SkipVought
SkipVought
JoelTXCive
  • Locked
  • Question Question
Excel Named Ranges and VBA
Replies
3
Views
1K
IDS
IDS

Part and Inventory Search

Sponsor

Back
Top