send arguments to auto open macro?

M

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
 
M

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 =
 
M

Martin Fishlock

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).
 
Top