send arguments to auto open macro?

[Martin]

Is it possible to send arguments to an auto open macro? I have a wscript
open excel with the ability to send an argument and I want the argument to
be passed to the macro.

Thanks
Martin

 

[mdupris]

As far as I know, you can't pass a parameter to the auto_open macro in
Excel. On the other hand, what you might consder is putting the
parameter value into the Windows registry and having VBA read it from
there.

= Marchand =

 

[Guest]

Or rather than using the registry one could try a simple text file and then
vba can open the text file and get the data (ie like an ini file).