Hello again,

I should also add that i was able to achieve the above using Automation, ie:

Set XLApp = CreateObject("Excel.Application")

XLApp.Visible = True
XLApp.workbooks.open XLApp.TemplatesPath & "Loader.xlt"

XLApp.Run "Module1.Load", someFilename

However, i'm trying to achieve the same thing via a command line ie. at a
dos prompt, "excel.exe Loader.xlt someFilename" but i just can't seem to
figure out how to pass someFilename either to excel or the Loader.xlt
template.


"Bing" wrote:

Hello,

I'm trying to programmatically, in one command line, to start excel with a
user specified excel template and the template itself then automatically
loads an arbitrary file, also specified in the same command line.

I know that i can specify in one command line "..\excel.exe myTemplate.xlt"
to have excel start and automatically load the template.

But how can you also automaticaly have the template then load an arbitrary
file from the SAME command line that started excel in the first place?
ie. "..\excel.exe myTemplate.xlt c:\myFile.txt"

Thanks