Need Comand line or VB Script

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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/kb/articles/Q184/2/73.ASP
ACC97: How to Use Automation to Create a Microsoft Excel Chart

http://support.microsoft.com/support/kb/articles/Q210/1/48.ASP
ACC2000: Using Automation to Create and Manipulate an Excel Workbook
 
Back
Top