View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Devin Linnington Devin Linnington is offline
external usenet poster
 
Posts: 9
Default Passing argument to Excel

This is easy, so don't worry about it. All you have to do is put "myFile.txt"
in "c:\documents and settings\USER\aplication data\excel\xlstart\" . This
folder might be under "c:\program files..." depending on your version of
windows/office. When that .txt file is stored under that xlstart thing it
will auto-load into excel whenever it is started. Also might want to change
the .txt to .cvs so you don't have to go through the wizard thing that pops
up when loading .txt files. (.cvs are comma delimited files). Hope that
helps...

P.S. I'm not sure if excel will auto-load non-.xls files, so you will just
have to try it out and see

"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