passing array between Excel '03 and VB '08

Expand Post »

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:

VB.NET Syntax (Toggle Plain Text)
Call gXLApp.Run(gwbTB.Name & "!ArrGather", gArr)
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?

Similar Threads

Visual basic macro in Excel. in Visual Basic 4 / 5 / 6
Query On Passing a datarow array as an argument in VB.NET

Tekito

Reputation Points: 10

Solved Threads: 0

Junior Poster in Training

Offline

56 posts
since Jan 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: sl.no in crystal report

Next Thread in VB.NET Forum Timeline: how to modify an exe without preparing a setup afresh

DaniWeb Message

Cancel Changes

User Name
Password