Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Comand line or VB
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comand Button arrows | Excel Discussion (Misc queries) | |||
Need Comand line or VB Script | Excel Programming | |||
Comand line or Vb | Excel Worksheet Functions | |||
remove comand button | Excel Programming | |||
comand 'IF" | Excel Programming |