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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sharing Arrays

Status
Not open for further replies.
bdavis96

bdavis96

Programmer
Joined
Feb 11, 2002
Messages
97
Location
US
Can Access and Excel share the same array done in VBA?
 
Sort by date Sort by votes
You should be able to store the array as a Variant and then pass that Variant as a parameter in a procedure or function call.
 
Upvote 0 Downvote
Or - if you are automating one from the other, you can just declare it as PUBLIC Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • News News
Excel will handle dynamic arrays
Replies
0
Views
175
combo
combo
kjv1611
  • Locked
  • Question Question
Excel: Sharing a Workbook for a Reference Table
Replies
5
Views
227
Gavona
Gavona
johk02
  • Locked
  • Question Question
Office365 question - sharing calendars
Replies
0
Views
92
johk02
johk02
ThomasBB
  • Locked
  • Question Question
Disable sharing of "flagged" mails
Replies
3
Views
188
kjv1611
kjv1611
laina222
  • Locked
  • Question Question
Excel 2010 - Arrays
Replies
2
Views
128
laina222
laina222

Part and Inventory Search

Sponsor

Back
Top