Member Avatar for Tekito
Tekito 0 Junior Poster in Training

I'm trying to write a program in VB2008 that uses a 2003 Excel spreadsheet as the interface. To help with this I am trying to pass data to and from macros inside the spreadsheet. I call a macro from VB with this line:

Call gXLApp.Run(gwbTB.Name & "!ArrGather", gArr)

where gArr is an array and ArrGather is a macro. Problem is even though I've specified the macro to take gArr as ByRef, the array is always passed byvalue - no updates to the array are reflected afterwards. Any ideas why Visual Basic 2008 can't pass variables by reference to excel 03 macros?

  • 1 Contributor
  • 0 Replies
  • 80 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.