I don't think so. In fact, when I tried it, excel opened my test template
file--not a new workbook based on the template.
Maybe you could save the template as readonly (on the network??), so that it
can't be saved. Then put your parm into a text file and have the
auto_open/workbook_open retrieve the value from that file.
Tim wrote:
I want to open excel using a template and pass an
argument that can be used in a macro, e.g excel.exe /t
template.xlt arg1
Does anyone know if this is possible?
--
Dave Peterson