View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Need Comand line or VB

you would have to open a workbook that has code in the workbook open event
to do all that.

then the command would be

Excel.Exe "C:\Myfolder\Trigger.xls"

as an example.

--
Regards,
Tom Ogilvy


"Chris" wrote in message
...
Hello ,

I am looking for a command line I can run in a batch file or a VB script
that I can open a excel file (name_todays Date.XLS) add to it , Print
Portrait, fit to one page wide, Legal, and to print gridlines, then save
the
settings then close out of excel.


Any help would be so appreciated.

Chris