Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Excel 2003 macros with VB2008 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

Answers