[AccessD] Automate Excel macro with parameters

jwcolby jwcolby at colbyconsulting.com
Fri Feb 27 14:50:18 CST 2009


Bows low before the Access God.

That worked just fine, at least in my simple test of passing a paramarray into a simple function 
that calls another function with a paramarray.  the only issue I see is that it turns the source 
parameters from whatever data type they might be into strings.

Next to test the actual Excel function.

John W. Colby
www.ColbyConsulting.com


Stuart McLachlan wrote:
> How about 
> 
> xlBook.Application.Run "MacroName", Join(MyParamArray()",")
> 



More information about the AccessD mailing list