Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Comand line or VB Script
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 Script
For vBscript, use 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) http://support.microsoft.com/support.../Q184/2/73.ASP ACC97: How to Use Automation to Create a Microsoft Excel Chart http://support.microsoft.com/support.../Q210/1/48.ASP ACC2000: Using Automation to Create and Manipulate an Excel Workbook -- 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 line or Vb | Excel Worksheet Functions | |||
command line Excel Script | Excel Discussion (Misc queries) | |||
Line selection from a cell script through a VBA macro | Setting up and Configuration of Excel | |||
which line mercy script | Excel Discussion (Misc queries) | |||
command line script for printing MS Excel 2000 document. | Excel Programming |