Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comand line
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 same the settings then close out of excel. Any help would be so appreciated. Chris |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
comand line
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 same the settings then close out of excel. Any help would be so appreciated. Chris |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
comand line
for VBscript, you need to look at Automation
http://support.microsoft.com/?id=167223 OFF97: Microsoft Office 97 Automation Help File Available (Q167223) http://support.microsoft.com/?id=260410 OFF2000: Microsoft Office 2000 Automation Help File Available (Q260410) -- 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 same 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 | |||
Need Comand line or VB Script | Excel Programming | |||
Need Comand line or VB | Excel Programming | |||
Comand line or Vb | Excel Worksheet Functions | |||
remove comand button | Excel Programming | |||
comand 'IF" | Excel Programming |