Excel 2003 macros with VB2008 RRS feed

  • Question

  • Trying to write a program in VB08 that uses Excel 2003 as an interface.  To help with this I am calling macros inside the Excel sheet from VB.  The problem is that even when I pass parameters byref to the macros, they always come back byvalue, ie unchanged.    So for example when I do:

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

    where I am passing array gArr for the macro to populate, it comes back still empty.  Any ideas why this is happens or how to get around it? 
    Tuesday, November 18, 2008 3:36 PM